eliminate one digit from the record

  • Hello All,

    I want to eliminate 1 digit from existing record from table for joing two tables.

  • busappa (12/17/2012)


    Hello All,

    I want to eliminate 1 digit from existing record from table for joing two tables.

    Please provide more information like tables definitions, sample records and expected output.

  • 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] 😉

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply