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.