Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
NUMERIC - sql equivalent?
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. Does...- queryjohn
- Thread
- Replies: 2
- Forum: NCR: Teradata
-
NUMERIC - sql equivalent?
The RDBMS is NCR Teradata, if that helps. -
NUMERIC - sql equivalent?
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...
