Validate Postcode

[brainonastick]

Hi there,

I need to add some special validation to a Postcode field so that it forbids entry of the following three strings:

"0000"

"@@@@"

"OSPC"

I haven't been able to figure out a calculation that will exclude these 3 strings.

Any help gratefully received.

Cheers,

Steven

[Genx]

...

If( Field = "0000" OR Field = "@@@@" OR Field = "OSPC" ; false ; true )

(the false and true might need to be reversed if you're acutally using FM validation)

Edited September 28, 2009 by Guest

[brainonastick]

Thank you!!!