Hi All, I am wondering if someone could help me figure out some SQL code.
For an assignment question on a SQL database i need to return any names which have 'an' in them e.g Andy but I don't want to return any names with and e.g Jones and Co.
I understand the like '%an%' but it is also returning the 'and' strings. How can I get around this?
Many thanks