| BIN |
Integer |
Text |
Return a string containing binary representation of a Integer. |
| LOWER |
Text |
Text |
Return Text in lower case. |
| UPPER |
Text |
Text |
Return Text in upper case. |
| REVERSE |
Text |
Text |
Return a reversed string. |
| TRIM |
Text |
Text |
Removes leading and trailing spaces from a string. |
| LTRIM |
Text |
Text |
Removes leading spaces from a string. |
| RTRIM |
Text |
Text |
Removes trailing spaces from a string. |
| LEN |
Text |
Integer |
Return the length of this string. |
| REPLICATE |
Text, Integer |
Text |
Return repeated a string a specified number of times. |
| SPACE |
Integer |
Text |
Returns a string of the specified number of space characters. |
| ASCII |
Text |
Integer |
Returns the ASCII value for the specific character. |
| LEFT |
Text, Integer |
Text |
Extracts a number of characters from a string (starting from left). |
| DATALENGTH |
Text |
Integer |
Returns the number of bytes used to represent an expression. |
| CHAR |
Integer |
Text |
Returns the character based on the ASCII code. |
| CHARINDEX |
Text, Text |
Integer |
Returns the starting position of the first occurrence of a string in another string. |
| NCHAR |
Integer |
Text |
Returns the character based on the ASCII code. |
| REPLACE |
Text, Text, Text |
Text |
Replaces all occurrences of a substring within a string, with a new substring. |
| SUBSTRING |
Text, Integer, Integer |
Text |
Extracts some characters from a string. |
| STUFF |
Text, Integer, Integer, Text |
Text |
Deletes a part of a string and then inserts another part into the string, starting at a specified position. |
| RIGHT |
Text, Integer |
Text |
Extracts a number of characters from a string (starting from right). |
| TRANSLATE |
Text, Text, Text, |
Text |
Returns the string from the first argument after the characters specified in the second argument are translated into the characters specified in the third argument. |
| SOUNDEX |
Text |
Text |
Returns a four-character code to evaluate the similarity of two expressions. |
| CONCAT |
Any, Any, ...Any |
Text |
Add several string representations of values together together. |
| CONCAT_WS |
Text, Any, Any, ...Any |
Text |
Add several string representations of values together together with separate. |
| UNICODE |
Text |
Integer |
Return an integer value (the Unicode value), for the first character of the input expression. |
| STRCMP |
Text , Text |
Integer |
Return 0 If string1 = string2, -1 if string1 < string2, this function returns -1, and 1 if string1 > string2 |
| QUOTENAME |
Text , Text |
Text |
Returns the string (first argument) with specified delimiters (second argument), defaulting to [] |
| STR |
Text, Integer?, Integer? |
Text |
Returns a number as a string with optionals length and decimals. |