Try the reverse logic in your rule, and see if that works: FAILS WHERE col1 = col2
"Alastair Burr" <[EMAIL PROTECTED]> wrote: >Hello everyone, > >I though that this would be easy but I can't see the wood for the trees >today: > >I have two columns that can both be null at the same time but mustn't both >contain the same value other than null and I'm trying to create a rule to >verify this. > >I first tried: col1 <> col2 - but the nulls fail, as expected, >then: (IFNULL(col1, col2, col1)) <> col 2 - but that's no good, >and then variations on the theme until it was time to ask for help! > >Any suggestions gratefully accepted. >Thanks & regards, >Alastair. > >---------------------------------- >A D B Burr, >St. Albans, UK. >---------------------------------- >[EMAIL PROTECTED] >---------------------------------- > > -- Albert Berry Full Time Consultant to PSD Solutions 350 West Hubbard, Suite 210 Chicago, IL 60610 312-828-9253 Ext. 32 __________________________________________________________________ McAfee VirusScan Online from the Netscape Network. Comprehensive protection for your entire computer. Get your free trial today! http://channels.netscape.com/ns/computing/mcafee/index.jsp?promo=393397 Get AOL Instant Messenger 5.1 free of charge. Download Now! http://aim.aol.com/aimnew/Aim/register.adp?promo=380455
