Skip to Main Content
SQL in a Nutshell, 3rd Edition
book

SQL in a Nutshell, 3rd Edition

by Kevin Kline
November 2008
Intermediate to advanced content levelIntermediate to advanced
591 pages
17h 28m
English
O'Reilly Media, Inc.
Content preview from SQL in a Nutshell, 3rd Edition

String Functions and Operators

Basic string functions and operators offer a number of capabilities and return string values as their results. Some string functions are dyadic, indicating that they operate on two strings at once. ANSI SQL supports the string functions listed in Table 4-9.

Table 4-9. SQL string functions and operators

Function or operator

Usage

Concatenation operator

Appends two or more literal string expressions, column values, or variables together into one string

CONVERT

Converts a string to a different representation within the same character set

LOWER

Converts a string to all lowercase characters

OVERLAY

Returns the result of replacing a substring of one string with another

SUBSTRING

Returns a portion of a string

TRANSLATE

Converts a string from one character set to another

TRIM

Removes leading characters, trailing characters, or both from a character string

UPPER

Converts a string to all uppercase characters

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Effective SQL: 61 Specific Ways to Write Better SQL, First Edition

Effective SQL: 61 Specific Ways to Write Better SQL, First Edition

John L. Viescas, Douglas J. Steele, Ben G. Clothier
SQL in a Nutshell, 4th Edition

SQL in a Nutshell, 4th Edition

Kevin Kline, Regina O. Obe, Leo S. Hsu

Publisher Resources

ISBN: 9780596155322Errata Page