How to compare if a field is in a specific format?

sushma.vasisht · New User Joined: 12 Nov 2006 Posts: 2

Are there any built-in function in ADSO to check if a given field is in a user defined format.

for example: i want to check if the record is in the format ABxxn.(where in the record should begin with 'AB' & xx should be eqaul to another varible say var-1 and n is any numeric value).

can i do it using LIKE command or SUBSTRING command? if so how?

vijayakumar.yellala · New User Joined: 19 Apr 2006 Posts: 45 Location: Chennai

Hello Susma,

Yes, we can check with perticular charcter also, right adso doc not with me, today night i will send u the function code.... Ok...

Regards
Vijay