eliminate one digit from the record

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » eliminate one digit from the record

eliminate one digit from the record

Rate Topic

Display Mode

Topic Options

Author

Message

busappa

Posted Monday, December 17, 2012 11:33 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, January 11, 2013 7:05 AM
Points: 1, Visits: 15

Hello All,

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

Post #1397567

rhythm.varshney

Posted Monday, December 17, 2012 11:39 PM

SSC Journeyman

Group: General Forum Members
Last Login: Thursday, March 21, 2013 2:14 AM
Points: 77, Visits: 184

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.

Post #1397569

vinu512

Posted Tuesday, December 18, 2012 12:14 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 3:56 AM
Points: 1,073, Visits: 1,480

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 Wink

Post #1397582

« Prev Topic | Next Topic »

Permissions