How to check the value if it is not a CHAR

sylvan_rydes · Post by **sylvan_rydes** » Thu Feb 08, 2007 4:33 pm

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

chulett · Post by **chulett** » Thu Feb 08, 2007 4:43 pm

Depends on your definition of CHAR. Have you checked the Alpha function?

narasimha · Post by **narasimha** » Thu Feb 08, 2007 4:45 pm

You can make use of the Num() function to filter out numeric data and take the rest.

sylvan_rydes · Post by **sylvan_rydes** » Thu Feb 08, 2007 5:00 pm

Hi Craig and Narsimha,

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

Sylvan

I_Server_Whale · Post by **I_Server_Whale** » Thu Feb 08, 2007 5:33 pm

You can mark the topic as "resolved".

ray.wurlod · Post by **ray.wurlod** » Thu Feb 08, 2007 11:35 pm

For something a little more esoteric search the forum for a server routine called IsValid() which allows you to check for particular data types.