Page 1 of 5
Home Whiteboard Online Compilers Practice Articles Tools
SQL - String Functions
SQL string functions are used primarily for string manipulation. The following table
details the important string functions −
[Link]. Function & Description
ASCII()
1
Returns numeric value of left-most character
CHAR()
2
Returns the character for each integer passed
CHARINDEX()
3
Returns the position of a substring within the given string.
CONCAT_WS()
4
Returns concatenate with separator
CONCAT()
5
Returns concatenated string
DIFFERENCE()
6 returns an integer value measuring the difference between the SOUNDEX()
values of two different expressions(strings).
ESCAPE()
7
Returns a text with escaped characters.
FORMAT()
8
Returns the formatted string.
LEFT()
9
Returns the extracting string.
[Link] 1/5
Page 2 of 5
LEN()
10
Returns the length of the given string.
LOWER()
11
Returns returns the lower case of the given string.
LTRIM()
12 Returns a string after removing all the white spaces and characters from the
string found on the left side.
NCHAR()
13
Returns the Unicode character based on the number code.
PATINDEX()
14
Returns the position of a pattern in a string.
QUOTENAME()
15
Returns a string with a delimiter
REPLACE()
16 Returns a new string by replacing all the occurrences of the particular part of
a string (substring) with a specified string.
REPLICATE()
17
Returns the repeated value.
REVERSE()
18
Returns a reversed string.
RIGHT()
19
Returns the rightmost characters from the actual(current) string.
RTRIM()
20
Returns a string after removing all trailing blanks.
SOUNDEX()
21
Returns the Soundex string.
SPACE()
22
returns a string consisting of N number of space characters.
STR()
23
Returns a number as string.
STRING_AGG()
24 Concatenates the values of string expressions and places separator values
between them.
[Link] 2/5
Page 3 of 5
STRING_SPLIT()
25
Splits a string into rows of substrings.
STUFF()
26 Returns a new string by inserting the second expression at the specified
deleted place.
SUBSTRING()
27
Returns the part of the character.
TRANSLATE()
28
Returns a string from the first argument.
TRIM()
29
Returns a trimmed string.
UNICODE()
30
Returns an integer value of the first character.
UPPER()
31
returns a string that has all the characters in upper case.
TOP TUTORIALS
Python Tutorial
Java Tutorial
C++ Tutorial
C Programming Tutorial
C# Tutorial
PHP Tutorial
R Tutorial
HTML Tutorial
CSS Tutorial
JavaScript Tutorial
SQL Tutorial
TRENDING TECHNOLOGIES
Cloud Computing Tutorial
Amazon Web Services Tutorial
Microsoft Azure Tutorial
[Link] 3/5
Page 4 of 5
Git Tutorial
Ethical Hacking Tutorial
Docker Tutorial
Kubernetes Tutorial
DSA Tutorial
Spring Boot Tutorial
SDLC Tutorial
Unix Tutorial
Chapters Categories
CERTIFICATIONS
Business Analytics Certification
Java & Spring Boot Advanced Certification
Data Science Advanced Certification
Cloud Computing And DevOps
Advanced Certification In Business Analytics
Artificial Intelligence And Machine Learning
DevOps Certification
Game Development Certification
Front-End Developer Certification
AWS Certification Training
Python Programming Certification
COMPILERS & EDITORS
Online Java Compiler
Online Python Compiler
Online Go Compiler
Online C Compiler
Online C++ Compiler
Online C# Compiler
Online PHP Compiler
Online MATLAB Compiler
Online Bash Terminal
Online SQL Compiler
Online Html Editor
ABOUT US | OUR TEAM | CAREERS | JOBS | CONTACT US | TERMS OF USE |
[Link] 4/5
Page 5 of 5
PRIVACY POLICY | REFUND POLICY | COOKIES POLICY | FAQ'S
Tutorials Point is a leading Ed Tech company striving to provide the best learning material on
technical and non-technical subjects.
© Copyright 2025. All Rights Reserved.
[Link] 5/5