Posted by Stu on 09/15/05 05:08

Are you sure it's a whitespace? It might be a line break. To verify,
you might try something like:

SELECT AccountNumber
FROM customers
WHERE AccountNumber LIKE '%" + CHAR(10)
OR AccountNumber LIKE '%' + CHAR(13)

Oh, and always be cautious about running an UPDATE statement with no
WHERE clause.

HTH,
Stu

• Next in forum: Need Help with "Left Outer Join"...
• Prev in forum: Removing white spaces in a varchar column
• Thread view: Re: Removing white spaces in a varchar column

[Reply to this message]