Viewing 3 posts - 1 through 3 (of 3 total)
To Lynn, CELKO, and rhythmk
My apologies for not positing the table script and sample data. I hope I didn't frustrate anyone. I got...
July 2, 2012 at 1:55 pm
Jeff,
I was looking that up. Then I saw your post. I read the article you suggested on "ISNUMERIC" It was very helpful....
May 10, 2012 at 9:31 am
Jeff,
That worked great! Thanks.
Here is my final query:
Select SEAL, * FROM toolsDB.CONTENT
Where Seal LIKE '%[^ 0-9A-Z]%'
OR DATALENGTH(LTRIM(RTRIM(Seal)))<>DATALENGTH(Seal)
Looks like I need to...
May 9, 2012 at 5:24 pm
Viewing 3 posts - 1 through 3 (of 3 total)