- SQL Tutorial
- SQL - Home
- SQL - Overview
- SQL - RDBMS Concepts
- SQL - Databases
- SQL - Syntax
- SQL - Data Types
- SQL - Operators
- SQL - Expressions
- SQL Database
- SQL - Create Database
- SQL - Drop Database
- SQL - Select Database
- SQL - Rename Database
- SQL - Show Database
- SQL - Backup Database
- SQL Table
- SQL - Create Table
- SQL - Show Tables
- SQL - Rename Table
- SQL - Truncate Table
- SQL - Clone Tables
- SQL - Temporary Tables
- SQL - Alter Tables
- SQL - Drop Table
- SQL - Delete Table
- SQL - Constraints
- SQL Queries
- SQL - Insert Query
- SQL - Select Query
- SQL - Select Into
- SQL - Insert Into Select
- SQL - Update Query
- SQL - Delete Query
- SQL - Sorting Results
- SQL Views
- SQL - Create Views
- SQL - Update Views
- SQL - Drop Views
- SQL - Rename Views
- SQL Operators and Clauses
- SQL - Where Clause
- SQL - Top Clause
- SQL - Distinct Clause
- SQL - Order By Clause
- SQL - Group By Clause
- SQL - Having Clause
- SQL - AND & OR
- SQL - BOOLEAN (BIT) Operator
- SQL - LIKE Operator
- SQL - IN Operator
- SQL - ANY, ALL Operators
- SQL - EXISTS Operator
- SQL - CASE
- SQL - NOT Operator
- SQL - NOT EQUAL
- SQL - IS NULL
- SQL - IS NOT NULL
- SQL - NOT NULL
- SQL - BETWEEN Operator
- SQL - UNION Operator
- SQL - UNION vs UNION ALL
- SQL - INTERSECT Operator
- SQL - EXCEPT Operator
- SQL - Aliases
- SQL Joins
- SQL - Using Joins
- SQL - Inner Join
- SQL - Left Join
- SQL - Right Join
- SQL - Cross Join
- SQL - Full Join
- SQL - Self Join
- SQL - Delete Join
- SQL - Update Join
- SQL - Left Join vs Right Join
- SQL - Union vs Join
- SQL Keys
- SQL - Unique Key
- SQL - Primary Key
- SQL - Foreign Key
- SQL - Composite Key
- SQL - Alternate Key
- SQL Indexes
- SQL - Indexes
- SQL - Create Index
- SQL - Drop Index
- SQL - Show Indexes
- SQL - Unique Index
- SQL - Clustered Index
- SQL - Non-Clustered Index
- Advanced SQL
- SQL - Wildcards
- SQL - Comments
- SQL - Injection
- SQL - Hosting
- SQL - Min & Max
- SQL - Null Functions
- SQL - Check Constraint
- SQL - Default Constraint
- SQL - Stored Procedures
- SQL - NULL Values
- SQL - Transactions
- SQL - Sub Queries
- SQL - Handling Duplicates
- SQL - Using Sequences
- SQL - Auto Increment
- SQL - Date & Time
- SQL - Cursors
- SQL - Common Table Expression
- SQL - Group By vs Order By
- SQL - IN vs EXISTS
- SQL - Database Tuning
- SQL Function Reference
- SQL - Date Functions
- SQL - String Functions
- SQL - Aggregate Functions
- SQL - Numeric Functions
- SQL - Text & Image Functions
- SQL - Statistical Functions
- SQL - Logical Functions
- SQL - Cursor Functions
- SQL - JSON Functions
- SQL - Conversion Functions
- SQL - Datatype Functions
- SQL Useful Resources
- SQL - Questions and Answers
- SQL - Quick Guide
- SQL - Useful Functions
- SQL - Useful Resources
- SQL - Discussion
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
SQL - String Functions
SQL string functions are used primarily for string manipulation. The following table details the important string functions −
| Sr.No. | Function & Description |
|---|---|
| 1 | ASCII()
Returns numeric value of left-most character |
| 2 | CHAR()
Returns the character for each integer passed |
| 3 | CHARINDEX()
Returns the position of a substring within the given string. |
| 4 | CONCAT_WS()
Returns concatenate with separator |
| 5 | CONCAT()
Returns concatenated string |
| 6 | DIFFERENCE()
returns an integer value measuring the difference between the SOUNDEX() values of two different expressions(strings). |
| 7 | ESCAPE()
Returns a text with escaped characters. |
| 8 | FORMAT()
Returns the formatted string. |
| 9 | LEFT()
Returns the extracting string. |
| 10 | LEN()
Returns the length of the given string. |
| 11 | LOWER()
Returns returns the lower case of the given string. |
| 12 | LTRIM()
Returns a string after removing all the white spaces and characters from the string found on the left side. |
| 13 | NCHAR()
Returns the Unicode character based on the number code. |
| 14 | PATINDEX()
Returns the position of a pattern in a string. |
| 15 | QUOTENAME()
Returns a string with a delimiter |
| 16 | REPLACE()
Returns a new string by replacing all the occurrences of the particular part of a string (substring) with a specified string. |
| 17 | REPLICATE()
Returns the repeated value. |
| 18 | REVERSE()
Returns a reversed string. |
| 19 | RIGHT()
Returns the rightmost characters from the actual(current) string. |
| 20 | RTRIM()
Returns a string after removing all trailing blanks. |
| 21 | SOUNDEX()
Returns the Soundex string. |
| 22 | SPACE()
returns a string consisting of N number of space characters. |
| 23 | STR()
Returns a number as string. |
| 24 | STRING_AGG()
Concatenates the values of string expressions and places separator values between them. |
| 25 | STRING_SPLIT()
Splits a string into rows of substrings. |
| 26 | STUFF()
Returns a new string by inserting the second expression at the specified deleted place. |
| 27 | SUBSTRING()
Returns the part of the character. |
| 28 | TRANSLATE()
Returns a string from the first argument. |
| 29 | TRIM()
Returns a trimmed string. |
| 30 | UNICODE()
Returns an integer value of the first character. |
| 31 | UPPER()
returns a string that has all the characters in upper case. |