Michelle wrote: "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???"
If you want odd numbers use the mod operator: Select * from MYTABLE Where MYCOLUMN Mod 2 <> 0 Into Selection Browse * From Selection HTH Jakob Lanstorp, M.Sc. The HydroGeophysics Group Department of Earth Sciences, University of Aarhus, Denmark Phone +45 8942 4350 / Fax +45 8610 1003 WWW (Danish) http://www.gfs.au.dk WWW (English) http://www.hgg.au.dk E-mail mailto:[EMAIL PROTECTED]
