Page 1 of 1

How to check the value if it is not a CHAR

Posted: Thu Feb 08, 2007 4:33 pm
by sylvan_rydes
Hi All,

I have a routine set up such that if a substring from a code is CHAR then it will proceed with the routine and If it is decimal then it will follow some other routine. So I want to know how can I verify that the string has all the values valid for only CHAR within the routine itself and make the decision.

Thanks in advance.

Sylvan

Posted: Thu Feb 08, 2007 4:43 pm
by chulett
Depends on your definition of CHAR. Have you checked the Alpha function?

Posted: Thu Feb 08, 2007 4:45 pm
by narasimha
You can make use of the Num() function to filter out numeric data and take the rest.

Posted: Thu Feb 08, 2007 5:00 pm
by sylvan_rydes
Hi Craig and Narsimha,

Thanks for your reply. Now I can make my way out. Thanks again.

Sylvan

Posted: Thu Feb 08, 2007 5:33 pm
by I_Server_Whale
You can mark the topic as "resolved". :wink:

Posted: Thu Feb 08, 2007 11:35 pm
by ray.wurlod
For something a little more esoteric search the forum for a server routine called IsValid() which allows you to check for particular data types.