replace function with diacritics 1

[tuzojazz]

Hi guys!

I have this code

PRINT REPLACE('EÉ', 'É' , 'X' )

and I get this

XX

and I want to consider diacritics to get

EX

how can I do it?

Thanks!

 

[gmmastros]

You need to use an accent sensitive collation. There are several to choose from. The one I use in the example below is also case sensitive.

PRINT REPLACE('EÉ', 'É' [!]collate Latin1_General_BIN[/!], 'X')

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[gmmastros]

Like I said... Latin1_General_Bin is also case sensitive, so...

PRINT REPLACE('Ee', 'E' collate Latin1_General_BIN, 'X')
-- Returns Xe

PRINT REPLACE('Ee', 'e' collate Latin1_General_BIN, 'X')
-- Returns EX

There's a ton of collations to choose from:

http://msdn.microsoft.com/en-us/library/ms144250.aspx

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[tuzojazz]

Thanks guys!

It works!!

 

[ESquared]

Note that you can put the collate clause on any of the three string literals in the replace expression... or on all three if you want.