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