Q: OR(ing)

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View


Can anybody show me if there is an alternative syntax to the following psudo
code in SQL:

SELECT tblA.first, tblA.second FROM tblA WHERE (((tblA.third)= 23) OR
(tblA.third)=42) OR (tblA.third)=56)));

i.e. is there a way of writing something like:

WHERE tblA.third = 23 OR 42 OR 56;


Thanks in advance


Re: Q: OR(ing)

On 04/05/2005, Geoff Jones wrote:

Quoted text here. Click to load it

WHERE tblA.third IN (23,42,56);


Re: Q: OR(ing)

Thanks Felix - brilliant!!!

Quoted text here. Click to load it

Site Timeline