Treading Å and A same word (urgent)

[Balbir Singh]

Please let me know how can I treat Å and A as a same character.
It's very urgent.

Thanks in advance.
-Balbir

[Jo]

Not sure what you're doing but, something like this should work but only if there is only ever one instance of 'Å' in each string. More fiddling around required if you need to handle multiple instances.

The string will be converted to a string containing an 'A', which you can then work with. (replace @expression with your field name)

DECLARE @expression varchar(12)
SELECT @expression = 'helloÅthere'
select STUFF(@expression, CHARINDEX('Å',@expression), 1, 'A&#39



------------
Balbir Singh at 1/22/01 6:51:31 PM

Please let me know how can I treat Å and A as a same character.
It's very urgent.

Thanks in advance.
-Balbir