Learn more about Toad for SQL Server
at Dell Software

Find solutions and downloads at the
Toad for SQL Server Support Portal

Toad for SQL Server 6.6

You are here: Edit SQL > Debug SQL > Supported Expressions > About Supported Expressions

About Supported Expressions

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”

 

Related Topics

About Debugging SQL

of