Select all rows where a varchar column converts to a decimal

Posted by Blankman on Stack Overflow See other posts from Stack Overflow or by Blankman
Published on 2010-04-24T18:37:26Z Indexed on 2010/04/24 18:43 UTC
Read the original article Hit count: 258

Filed under:
|
|

I have a varchar column that has generally has a decimal value, but some times there is some garbage text characters in that field.

Is it possible to filter in the WHERE clause for rows that sucessfully convert to a decimal value?

I am using sql-server 2005

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about sql