#DateForumTypeThreadPost
212 Jun 2008 @ 08:48 PDTUDAReplyto check is a string is numeric or notUpper(col1)=lower(col1) will not work.Ex:say the column col1 = '6-98-89 9' which fits in char(9).Now Upper(col1)=lower(col1) will be same. In this case it would pass the check & while inserting th...
106 Jun 2008 @ 11:00 PDTUDATopicto check is a string is numeric or not[font=Arial][/font]Hi, Is there any UDF to check if a string (in my case its CHAR(9)) is numeric or contains special chars/alphabets?My requirement is... i need to consider only those records whic...