Learn more about Toad for SQL Server
at Quest.com

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

< To bookmark a page, right-click the Page Title and select Add to Favorites / Bookmark This Page

Toad for SQL Server 5.7

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”