The reason is like i dont know how to use the functions here what i know is update command but in my DB there thousands of Records then how can i convert them with the above mentioned Function . Please guide me what to do ?

Koen Verbeeck (10/10/2013)Google for a tuturial on SQL Server functions and read it.You are responsible for your data and before you let any update statement loose on it, you should understand what you are doing.

Yes i Agree , that Data is getting updated in the Capital format itself , so i came here to know what can be done