String Functions in SQL

String Functions:-
Before we start look at the "String Functions", first we should understand what is string? and what is functions.

What is String?

In SQL, Collection of character or combination of word is called as "String". Data whichever stored using following datatype is called as string

• Varchar
• NVarchar
• Text
• Char
• NChar

What is Functions?

Function is a set of code or procedure which will perform some specfic operation is known as functions.

What is String Functions?
The Function which is written to perform string related opearations like...

• Findling character length
• Searching some character from collection of texts/paragraphs
• Replacing some character with new character
• Spliting a word based on some delimiter
• etc.,

Hope above explanation is helpful to understand about what is string functions

 

The following commands are the functions which are used to perform the string operations..

• ASCII
• NCHAR
• SOUNDEX
• CHAR
• PATINDEX
• SPACE
• CHARINDEX
• QUOTENAME
• STR
• DIFFERENCE
• REPLACE
• STUFF
• LEFT
• REPLICATE
• SUBSTRING
• LEN
• REVERSE
• UNICODE
• LOWER
• RIGHT
• UPPER
• LTRIM
• RTRIM

Note: We will Explain about each functions in detail in further posts..