Posted: Thu Sep 19, 2002 6:36 am Post subject: Can a Filter Node have multiple statements
Acolyte
Joined: 19 Sep 2002 Posts: 74 Location: Newton, MA
I need to do the following in a filter node:
substring("Body"."AC_NO" from 4 for 2)= '74A';
substring("Body"."AC_NO" from 4 for 2)= '74B';
substring("Body"."AC_NO" from 4 for 2)= '74C';
and so on - is it possible to have a filter node evaluate several statements? if so, do I need an OR between them?
substring("Body"."AC_NO" from 4 for 2)= '74A' ||
substring("Body"."AC_NO" from 4 for 2)= '74B' ||
substring("Body"."AC_NO" from 4 for 2)= '74C'; _________________ M Marquis
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum