Jump to content

Need SQL query to return any words with '%an%' but not return records with 'and'


Recommended Posts

Posted

Hi All, As the title says I am hoping to find out how i can write sql code that will return any words that have the characters 'an' in them but not return the word 'and' as well.  I can manage to get all words with an by using %an% but it is also returning the word 'and' along with it.  Can anyone help?

Thanks

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...