Strings and how they are processed

Welcome to the Brandeis Training website!

You are not logged in or enrolled in this course, so you will not be able to see all of the content. On the left side you will find the table of contents. But there are some free trial lessons there, which you can recognize by the same yellow background and the lock symbol.

SQLScript provides a large number of built-in, scalar SQL functions for processing character strings. These will be explained in the following topics.

To repeat

There are two types of string literals:

  • Simple ASCII character strings are written in apostrophes, e.g. 'Text'
  • Unicode string literals becomes another big one N in front of it, for example N'Jörg'

The difference between ASCII strings and Unicode strings becomes clear in the following topic.

Pages 166-184 in the book