Hello Gurus, I’ve a table that has a column with a text data type. When th
ey
imported the data from a different system some non ASCII character slipped
into the table. What would be the best way to get rid of them?
For example: A man ne£ds ??help. to A man needs help
thanks in advance.Hi
If this is a one off, you may want to try:
UPDATE myStrings
SET str = STUFF(str,PATINDEX('%[^A-Z ]%',str),1 ,'')
WHERE PATINDEX('%[^A-Z ]%',str) > 0
WHILE @.@.ROWCOUNT > 0
BEGIN
UPDATE myStrings
SET str = STUFF(str,PATINDEX('%[^A-Z ]%',str),1 ,'')
WHERE PATINDEX('%[^A-Z ]%',str) > 0
END
John
"KB" wrote:
> Hello Gurus, I’ve a table that has a column with a text data type. When
they
> imported the data from a different system some non ASCII character slipped
> into the table. What would be the best way to get rid of them?
> For example: A man ne£ds ??help. to A man needs help
> thanks in advance.
>|||http://www.aspfaq.com/2445
"KB" <KB@.discussions.microsoft.com> wrote in message
news:F11D992A-CC05-4776-B43A-A3AB8412F291@.microsoft.com...
> Hello Gurus, I’ve a table that has a column with a text data type. When
> they
> imported the data from a different system some non ASCII character slipped
> into the table. What would be the best way to get rid of them?
> For example: A man ne£ds ??help. to A man needs help
> thanks in advance.
>|||Great Help! Thank you gentlemen.
"KB" wrote:
> Hello Gurus, I’ve a table that has a column with a text data type. When
they
> imported the data from a different system some non ASCII character slipped
> into the table. What would be the best way to get rid of them?
> For example: A man ne£ds ??help. to A man needs help
> thanks in advance.
>
No comments:
Post a Comment