Jump to content

Andreamcc

Members
  • Content Count

    2
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Andreamcc

  • Rank
    Newbie
  1. 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
  2. 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 New...