ToString

Table of Contents

Overview
Prototype

Example

See also
Related

Overview

Returns the number as a string, so that + concatenates it instead of adding it.

Prototype

String ToString(Numeric value)

Example

Returns 'Prefix1050Suffix'.

SELECT 'Prefix' + 10 + ToString(50) + 'Suffix' as Result FROM Single

See also

Scalar Functions

Home

The home page

SQL :: Abs

Returns the absolute value of a number.

SQL :: Ceil

Returns the smallest whole number that is greater than or equal to the given number.

SQL :: Checksum

Returns a simple 16-bit checksum (0 to 65535) of the value's ASCII bytes. It is fast but not collision resistant; use Sha256 when the value must be unique.

SQL :: Coalesce

Returns the first of the given values that is not null. Accepts any number of values.

SQL :: Concat

Concatenates all of the given values that are not null. Accepts any number of values. The + operator can also be used to concatenate, but a null on either side of + makes the whole result null.

SQL :: DateAdd

Adds offset intervals to a date/time value and returns the new date/time. Use a negative offset to subtract. Interval names are not case-sensitive.

SQL :: DateDiff

Returns the number of intervals between two date/time values (date2 minus date1). See DateAdd for the interval names.

SQL :: DateTime

Returns the server's current local date and time, formatted with the optional .NET date/time format string.

SQL :: DateTimeUTC

Returns the current UTC date and time, formatted with the optional .NET date/time format string. See DateTime for the format specifiers.