Can we use 'OR' in Search statement like AND

vijayamadhuri · Active User Joined: 06 Apr 2005 Posts: 180

hello
Can we use OR in a search stATEMENT AS SHOWN BELOW.
OR IS IT THAT ONLY AND CAN BE USED.

pLEASE CLARIFY.

priyesh.agrawal · Posted: Tue Dec 19, 2006 11:06 am

Did you get any problem using that...

I never used, but what I see in manual for a SEARCH statement ... Complex conditions also falls under the Conditional expressions can be used with a WHEN phrase (serial search)...

Arun Raj · Posted: Tue Dec 19, 2006 11:07 am

Hi

You can surely use OR also

Thanks
Arun

guptae · Posted: Tue Dec 19, 2006 11:10 am

Hi ,

I dont thk there is ne problem in using OR

DavidatK · Posted: Tue Dec 19, 2006 8:11 pm

The compiler will let you use 'OR', however, the way you have it stated may not yield the result you expect. Mixing ?AND?s and ?OR?s together without grouping them together with ?(? ?)? is not a good practice. Is below what you wanted? Probably not, but is one interpretation.