Andreamcc Posted February 23, 2020 Share Posted February 23, 2020 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 Link to comment Share on other sites More sharing options...
Makwana Prahlad Posted February 25, 2020 Share Posted February 25, 2020 select * from [TableName] where [ColumnName] Like '%an%' and not [ColumnName] Like '%and%' Hi, Try this, i hope this will work. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now