#string functions in sql server

A string function accepts a string value as an input and returns a string value regardless of the data type. They're used to convert an existing string value to a different format, change the letter cases, retrieve a portion of it, or determine the length

A string function accepts a string value as an input and returns a string value regardless of the data type. They’re used to convert an existing string value to a different format, change the letter cases, retrieve a portion of it, or determine the length of it. They are utilized in reports, logic implementation, and data analysis on a daily basis. This will be a series of postings since we will…

Various available string functions in SQL Server TIP # 63

  There are various functions available in SQL Server and it is good to know all of them you never know when they will be helpful to you.

So lets start one by one.

1) LEN :-   By the name it is clear that LEN function give length of the parameter

For example :-

DECLARE @Name AS VARCHAR(100) = ‘Rajat’ SELECT LEN(@Name)

2) LTRIM & RTRIM :-

By the name it is clear that both LTRIM  & RTRIMtri…