G Guest Mar 7, 2006 #1 In a column of 7000 records how can I find only those that have 9 in the 4th&5th or 7th column?
D Duane Hookom Mar 7, 2006 #2 Your where clause might look like: WHERE FieldD = 9 or FieldE = 9 or FieldG = 9