Subject SQL Query like/not like with and/or From trevor <bob@bob.com> Date Mon, 02 Sep 2024 08:13:56 -0400 Newsgroups dbase.getting-started Windows 10- dBase PLUS 2.21 Using where  to create a sql query I have found a difference between using 'like' and 'not like' in conjunction with or/and Using a simplified table as example abname.dbf (single field),bname records rows (char) TP, JM, TPJM,SP, MP so using where like with or select * from abname where bname like 'T%' or  bname like 'J%' returns  rows TP,JM, TPJM - result correct as expected using where not like with or select * from abname where bname not like 'T%' or  bname not like 'J%' returns All records rows not correct expected only SP,MP However using "and" -not- "or" select * from abname where bname not like 'T%'  and  bname not like J%' returns SP, MP as desired but unexpected as only single field row. using select * from abname where bname like 'T%' and  bname like 'J%' returns no records as expected. It would appear that 'or' with  "like" works/queries on each rows as expected but 'and'  with "not like" appears to works/queries  the whole table as one. Can anyone offer explanation where using  'and' in 'not like' gives a correct result where I would have expected the use of 'or' to be correct. Thanks Trevor