String function operate on binary data, character strings, and expressions. The string functions are:
ascii
char
charindex
char_length
difference
lower
ltrim
patindex
replicate
reverse
right
rtrim
soundex
space
str
stuff
substring
to_unichar
uhighsurr
ulowsurr
upper
uscalar
String functions can be nested, and they can be used in a select list, in a where clause, or anywhere an expression is allowed. When you use constants with a string function, enclose them in single or double quotes. String function names are not keywords.
Each string function also accepts arguments that can be implicitly converted to the specified type. For example, functions that accept approximate numeric expressions also accept integer expressions. Adaptive Server automatically converts the argument to the desired type.
When a string function accepts two character expressions but only one expression is unichar, the other expression is “promoted” and internally converted to unichar. This follows existing rules for mixed-mode expressions. However, this conversion may cause truncation, since unichar data sometimes takes twice the space.
