NUMERIC - sql equivalent?

[queryjohn]

I have a table column that is defined as CHARACTER. However, this field should only contain numeric values. I would like to run a query that returns all rows where this field contains a non-numeric value (not including nulls).

In COBOL, I'd use the keywords NOT NUMERIC to check for this. Is there an SQL function or keyword that is equivalent?

 

[fluteplr]

Depends on what dbf you are using.

For example in SQL Server you could use:

select * from mytable
where mot isnumeric(myfield)

 

[fluteplr]

Depends on what dbf you are using.

For example in SQL Server you could use:

select * from mytable
where not isnumeric(myfield)

 

[queryjohn]

The RDBMS is NCR Teradata, if that helps.

 

[karluk]

This question would be more appropriate for forum328, which is specific to Teradata issues. Perhaps one of the experts there can help you.