Subject | Select when string can be cast? |
---|---|
Author | Harriv |
Post date | 2009-10-27T16:22:04Z |
Hi,
Is there a way to select by a VarChar field all the records which can
be casted as integer?
Something like: Select * from MYTABLE where Cast(ColumnA as Integer)
Is there a way to select by a VarChar field all the records which can
be casted as integer?
Something like: Select * from MYTABLE where Cast(ColumnA as Integer)