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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Validating Numbers & Strings

Status
Not open for further replies.

kathi

Programmer
Jun 17, 2002
9
GB
I need to inspect some varchar variables in a SQL Stored procedure in UDB DB2 v8.1, to determine whether their contents are all numbers or whether there are some non-numeric characters in there. I cannot change the datatype - it has to be a varchar. We were able to do this in Sybase using the patindex command, but so far have been unable to find a method of checking for a range of characters or numbers in a variable. Help please.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top