ShowScalarFunctions

Table of Contents

Overview
Prototype
Returns

Example

See also
Related

Lists the built-in scalar functions with their parameters and descriptions.

ShowScalarFunctions()

Name, ReturnType, Parameters and Description. Each prototype is also returned as a message.

Lists the scalar functions.

EXEC ShowScalarFunctions

SQL :: ToProper

Returns the value with the first letter of each word capitalized (title case).

SQL :: ToString

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

Returns the value converted to upper case.

Removes white space from the start and end of the value. When characters is given, each of those characters is removed from the start and end instead.