Ltrim rtrim no working with UPDATE

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » T-SQL (SS2K5) » Ltrim rtrim no working with UPDATE

16 posts, Page 2 of 2

««1 2

Ltrim rtrim no working with UPDATE

Rate Topic

Display Mode

Topic Options

Author

Message

David Burrows

Posted Monday, February 23, 2009 6:54 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 6:36 AM
Points: 6,351, Visits: 5,367

And this should correct the data....

UPDATE #tablename 
SET colname = STUFF(colname,1,1,'') 
WHERE colname LIKE '%WDT' 
AND colname <> 'WDT'

Far away is close at hand in the images of elsewhere.

Anon.

Post #662526

Sriram-288748

Posted Monday, February 23, 2009 6:56 AM

SSC Veteran

Group: General Forum Members
Last Login: Monday, April 29, 2013 12:19 AM
Points: 219, Visits: 326

I have a space on the right side so changed the query accordingly . but afraid it shows no records.

SELECT DISTINCT
[Code] = ASCII(right(LTRIM(valuecode), 1)),
[Character] = '[' + right(LTRIM(valuecode), 1) + ']'
FROM ListOfValues
WHERE (valuecode LIKE '%WDT%')
-- 32 ,[ ]

SELECT valuecode,CAST(valuecode as varbinary(4))
FROM ListOfValues
WHERE valuecode LIKE 'WDT%'
AND valuecode <> 'WDT'
-- No Records

Sriram

Post #662527

David Burrows

Posted Monday, February 23, 2009 7:01 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 6:36 AM
Points: 6,351, Visits: 5,367

You need to do

LIKE '%WDT'

not

LIKE 'WDT%'

Far away is close at hand in the images of elsewhere.

Anon.

Post #662534

Sriram-288748

Posted Monday, February 23, 2009 7:08 AM

SSC Veteran

Group: General Forum Members
Last Login: Monday, April 29, 2013 12:19 AM
Points: 219, Visits: 326

Yes David, I have done that rather tried both 1st time only, it returned no records.

Sriram

Post #662542

David Burrows

Posted Monday, February 23, 2009 7:23 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 6:36 AM
Points: 6,351, Visits: 5,367

OK. Maybe there are trailing non printable chars as well, should have thought of that Blush

.

Try

LIKE '%WDT%'

Far away is close at hand in the images of elsewhere.

Anon.

Post #662565

Sriram-288748

Posted Wednesday, February 25, 2009 2:17 AM

SSC Veteran

Group: General Forum Members
Last Login: Monday, April 29, 2013 12:19 AM
Points: 219, Visits: 326

Thanks for you time friends. could not solve the issue, updated the col to varchar datatype.

Thanks again.

Sriram

Post #664078

« Prev Topic | Next Topic »

16 posts, Page 2 of 2

««1 2

Permissions