-
I want to check if some character is not a number,but I don't know what must I use.
I want to do something like this:
If substr(field,1,1) "is not number" then....
Just to check if the first charater of the field is a number o a letter.
But "is not number" is wrong,and I don't know what to use.
Thanks in advance
-
Hi, jamoji!
This could be the equivalent of "is not number" function:
Code:
if instr('0123456789',substr(field,1,1))=0 then
or
Code:
if substr(field,1,1) NOT BETWEEN '0' AND '9' then
HTH,
Ales
-
Thanks very much Ales!
How can I be so silly....By the way,what's HTH?
Regards
-
Hope That Helps ... :-))
A.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|