Quotation Marks

Quotation marks are used to delimit character strings.

Normally, the quotation marks are optional; however, quotation marks are required when

Either single or double quotation marks can be used, but the string must end with the same type of quotation mark that was used at the start, as shown in the following example:

'This is a character string.'

"This is a character string."

To use the same type of quotation mark as a literal character inside the string, a backslash (\ - Escape) must precede it as shown in the following example:

'This is a quotation mark (\') inside a string.'

To reinforce the explicit use of quotation marks around character strings, you can switch the SET QUOTING command on. Then, when the software encounters an unquoted, non-numeric character string, a warning message is generated, as shown below:

Note: Character strings that are valid numbers do not elicit warnings.

Examples

If FirstName and LastName are both fields in the EntitySet Employees, and you use the command:

find Employees where LastName = Firstname

then employees with names such as John John or Leslie Leslie are sought, i.e., the employee's last name is identical to the first name. The software makes no distinction between uppercase and lowercase letters in the names of objects.

On the other hand, if you use

find Employees where LastName = 'Firstname'

then employees with the string Firstname in the LastName field are sought, i.e., John Firstname, Leslie Firstname, and so on.

You cannot enter the following command

find Departments where DeptName = where

because WHERE is a command keyword. The command parser sees the second instance of WHERE as being out of context and raises an error. To find a DeptName whose value is where, you must enter

find Departments where DeptName = 'where'