Learn more about Toad for SQL Server Find solutions and downloads at the |
Toad for SQL Server 6.6 |
Toad supports the following expressions:
Expression |
Description |
Examples |
---|---|---|
Literal |
Represents a literal string value. Literal string values are enclosed with beginning and ending single quote ( ’r;’ ) characters. If you need to create a literal string that includes a single quote in it, enter two single quotes ( ’’ ) where you need the actual quote and then close the string with a single quote ( ’ ). |
’r;Hello there’ ’r;Don’’t’ |
Number |
Uses a floating point number format. |
1.23E-5 .8 10.2 5123 |
Operator |
Uses any supported operator. See Supported Operators for more information. |
+ . and |
Identifier |
Includes any expression that does not fit in the other expression categories. When using a ”r; or ` character, an identifier can be quoted to any string. |
@variable ”r;A long identifier” |