I have a SQL select statement, but I don't know how to finish it. The part in red works fine, but it's the part in blue I don't know how to do. BAsically I need to use the LIKE clause but also ignore a specific record which the LIKE clause finds.

SELECT product WHERE partno LIKE "111%" NOT 1114

Any suggestions on how to do this?

SELECT product
WHERE partno LIKE '111%'
AND partno != '1114'

String character generally must be surrounded by single quotes, not double.

Thanks, that seemed to do the trick. I was using single quotes also, I used double quotes in the example by mistake (wasn't a copy/paste).