using contains for multiple numbers
Jay Ashworth
jra at baylink.com
Fri Jul 11 09:44:32 PDT 2014
----- Original Message -----
> From: "Richard D. Williams" <richard at appgrp.net>
> I have not done this, for a long time and I know I have see it done.
>
> I have a field that may or may not contain a number (0-9).
>
> I want to write an IF statement testing this to be true or false.
>
> Is it,
> if : 4 co "123467890"
>
> or
>
> if : "1234567890" co 4
>
> or
> if : "0|1|2|3|4|5|6|7|8|9" co 4
The second, unless you can't guarantee that 4 is a single character field,
in which case the third is smarter. The third is always more rugged.
Cheers,
-- jra
--
Jay R. Ashworth Baylink jra at baylink.com
Designer The Things I Think RFC 2100
Ashworth & Associates http://www.bcp38.info 2000 Land Rover DII
St Petersburg FL USA BCP38: Ask For It By Name! +1 727 647 1274
More information about the Filepro-list
mailing list