Home Forums SQL Server 2005 T-SQL (SS2K5) Searching for case sensitive data RE: Searching for case sensitive data
rons-605185
SSCommitted
Points: 1618
More actions
April 16, 2009 at 6:48 am
#978757
Thanks Flo and Bob:
The Collate statement allowed me to find the incorrect string and the Update query allowed me to correct the data
UPDATE sometable
SET someColumn = REPLACE(someColumn,'cqs','CQS')
WHERE somecolumn LIKE 'cqs%'
Thanks again:-)