Posted on 2006-11-13
Does anyone know a way to filter out non-numeric characters in a char field?
I am looking for something like the following that works with Teradata:
Select * from table where IsNumeric(field1) = 1
I have a problem converting a string to an integer on a field that "should" contain all numbers, but it doesn't. Or if there's any way to not get a blasted "Bad Character in format or data" error whenever I try to convert the field to an integer.