Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

eliminate one digit from the record Expand / Collapse
Author
Message
Posted Monday, December 17, 2012 11:33 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Monday, December 17, 2012 11:39 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, September 19, 2013 4:30 AM
Points: 78, Visits: 195
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
Posted Tuesday, December 18, 2012 12:14 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, April 08, 2014 2:40 AM
Points: 1,118, Visits: 1,573
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
Post #1397582
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse