SQL String Functions

SQL provides us with a number of tools that give us the ability to manipulate string values. This section of the site gives details of the various functions available and demonstrates real world examples of their use.

The syntax of the string functions can vary for different database systems. For example both Oracle and SQL Server have a string function that can extract a specified section of a string. In Oracle and Microsoft Access this function is called SUBSTR, in SQL Server it is called SUBSTRING. These pages give details of the differing naming conventions / syntax for the different databases of SQL Server, Oracle, Microsoft Access and MySQL.

For a more detailed article on each of the string functions please click the Function names below.

Many string functions are used in combination with other string functions to achieve a desired solution to a problem.

SQL String Functions

privacy policy