SQLScript provides a large number of built-in, scalar SQL functions for processing character strings. These will be explained in the following topics.
There are two types of string literals:
- Simple ASCII character strings are written in apostrophes, e.g.
- Unicode string literals becomes another big one N in front of it, for example
The difference between ASCII strings and Unicode strings becomes clear in the following topic.