Tasks

Back Next

String and numeric literals

You can include numeric or string literals.

Enclose string literals within single quotation marks. For example:

'Alice Davis'

String literals are case sensitive and can contain any character except a single quotation mark. For example, the following string is not allowed:

'Joan's car'

To return a string containing a single quotation mark, use the CHR function:

'Joan' || CHR(39) || 's car'

Do not use single quotation marks with numeric literals. Just enter the number you want to include. For example:

.05

$$Sales_Tax

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.