-
Treading Å and A same word (urgent)
Please let me know how can I treat Å and A as a same character.
It's very urgent.
Thanks in advance.
-Balbir
-
Treading Å and A same word (urgent) (reply)
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'
------------
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|