SQL LIKE ANd NOT LIKE

[Andreamcc]

@ScottPletcher

WHERE string LIKE '%an%' AND '.' + string + '.' NOT LIKE '%[^a-z]and[^a-z]%'

Thanks! I tried that....but it is still bringing up a record with 'and' (sorry table isn't very well poulated yet but basically i only want it to return Harper Collans...