String types are used when you wish to store a character string of a fixed or variable length, including very large character strings.


Literals

---

String literals use the single quote (') character to identify themselves as such. Any single quotes enclosed inside of the literal must be escaped by prefacing them with another single quote. In addition, single character constants may be specified using their literal value or by prefacing their ordinal character set position with the pound sign (#) character.

Literal Examples

---

-- This example specifies a VARCHAR literal

SELECT * FROM Customer WHERE Name = 'Acme Boot Makers'

-- This example specifies a VARCHAR literal with
-- embedded quotes

SELECT * FROM Customer WHERE Name = 'Bill''s Shoes'

-- This example specifies two CHAR literals (a carriage
-- return and line feed) using pound sign (#) notation

SELECT * FROM Documentation WHERE Notes LIKE '%'+#13+#10+'%'

SQL 2003 Standard Deviations

---

The following areas are where ElevateDB deviates from the SQL 2003 standard: