Hi Michelle, The simplest way is to use "any()' select * from MyTable where MyCol = any(3,5,7)
or, if the values are strings, select * from MyTable where val(MyCol) = any(3,5,7) Gary >>> "Michelle White" <[EMAIL PROTECTED]> 02/12/03 05:55PM >>> Hi Listers!!! I have got a simple SQL problem. I have a column with 7-10 different values (say 1,2,3,4,5,6,7). How can I construct a SQL query to select records of values no 3, 5 and 7??? Can someone please teach me??? Michelle _________________________________________________________________ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 5504 ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ********************************************************************** --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 5511
