Getting rid of Tick - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Getting rid of Tick

Author

Topic

SQLNOVICE999
Yak Posting Veteran

62 Posts

Posted - 2011-10-05 : 11:12:34

Guys I tried doing replace it did not work... I have a column with latin names from where I want to take out tick

Universidad Tecnológica de Coahuila

Anyone please let me know how I can do that?

Thanks,
Laura

robvolk
Most Valuable Yak

15732 Posts

Posted - 2011-10-05 : 11:15:19

UPDATE myTable SET myColumn=REPLACE(myColumn,'ó','o')

SQLNOVICE999
Yak Posting Veteran

62 Posts

Posted - 2011-10-05 : 11:17:57

Is it only in vowels if so then I can have multiple replaces.. if not then I should use a table to do replace..

quote:
Originally posted by robvolk

UPDATE myTable SET myColumn=REPLACE(myColumn,'ó','o')

robvolk
Most Valuable Yak

15732 Posts

Posted - 2011-10-05 : 13:29:49

Why do you need to remove the accent mark? Are you doing comparisons for search? You can specify an accent-insensitive collation to have it ignore them:

-- accent-sensitive
select case when
'Universidad Tecnológica de Coahuila' COLLATE Latin1_General_CI_AS
LIKE 
'Universidad Tecnologica de Coahuila' COLLATE Latin1_General_CI_AS
THEN 'Yes' ELSE 'No' END

-- accent-insensitive
select case when
'Universidad Tecnológica de Coahuila' COLLATE Latin1_General_CI_AI
LIKE 
'Universidad Tecnologica de Coahuila' COLLATE Latin1_General_CI_AI
THEN 'Yes' ELSE 'No' END

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2011-10-05 : 14:59:44

A good sheep-dip can be good for getting rid of ticks - just throwin' that out there.

Be One with the Optimizer
TG

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources