Various available string functions in SQL Server TIP # 63
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…
View On WordPress














