Welcome to SQL Server Central busappa.
Following should do what you want :
Declare @string Varchar(10)
Set @string = 'Vinu'
Select STUFF(@String, LEN(@String), 1, '')
If this is not what you are looking for....then please have a look at the link in my signature and post DDL, sample data and the expected result set exactly as shown in the link......you would definitely get a solution to your requirements if you post accordingly.
Vinu Vijayan
For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉