Built in Function in sql server 2005/08 | String Function

There are  number of built in function in sql server 2005 and 2008 .
But Whatever I am showing here is most Useful Function In sql server.
If you want to know more then Google It.

1.Len Function(To Calculate the lenght of string)
2.Replace Function(Replace one word with another one)
3.Reverse Function (it is like Morror image )
4.Left ,Right  Function
4.Ltrim ,Rtrim function (Remove the space)
5.Substring 
6.CharIndex and PatIndex

Share This