Page 1 of 1

Look up not found

Posted: Tue Oct 12, 2010 1:08 pm
by raji33
Hi Gurus,

can any one please help me understand this constraint

(StageVar = 'Y' and lkp.NOTFOUND = @false ) or lkp.NOTFOUND


Thanks
in advance

Posted: Tue Oct 12, 2010 1:28 pm
by chulett
It returns TRUE if (StageVar = 'Y' and the lookup succeeds) or if the lookup fails.

Posted: Tue Oct 12, 2010 1:40 pm
by raji33
Thanks chulett