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.