Andreamcc Posted February 23, 2020 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
Makwana Prahlad Posted February 25, 2020 Posted February 25, 2020 select * from [TableName] where [ColumnName] Like '%an%' and not [ColumnName] Like '%and%' Hi, Try this, i hope this will work.
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