Hi, Try the following:
WHERE not (field like '%c%' or field like'%C%') Cheers, On Wed, 28 Jul 2004 22:23:40 +0100, John Berman <[EMAIL PROTECTED]> wrote: > Hi > > Sure this is easy > > Im trying to create a simple select query but I want to return records > unless a field contains a C or c so would it be something like > > where field <> 'c' or 'C' > > Regards > > John B > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- Tiago Serafim [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
