Q: OR(ing)

[Geoff Jones]

Hi

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

Geoff

[Felix Geerinckx]

On 04/05/2005, Geoff Jones wrote:

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

WHERE tblA.third = 23 OR 42 OR 56;

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

--
felix

[Geoff Jones]

Thanks Felix - brilliant!!!
"Felix Geerinckx" <fe*************@gmail.com> wrote in message
news:xn**************@news.easynews.com...

On 04/05/2005, Geoff Jones wrote:

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

WHERE tblA.third = 23 OR 42 OR 56;

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

--
felix