Results 1 to 2 of 2
Thread: Alike instead of like
2013-07-11, 21:01 #1
- Join Date
- Apr 2012
- Thanked 0 Times in 0 Posts
Alike instead of like
I've only just resumed my relationship with Access after a nearly 10 year break. With older versions of Access (2003 and earlier) the 'like' reserved word was used in SQL to find anything that contained what you placed after the 'like' term. Therefore for example if the query contained:
all records that contained fred such as alfred or fred or frederick would be returned.
However, I've just loaded Access 2007 on my system and when I use the reserved word 'like' in this, it automatically changes the 'like' to 'Alike' and then promptly doesn't return anything. The only time it does is when I have the string identical to the data in the field. eg. Alike "Frederick" or Alike "Alfred" etc. It's even case sensitive which is easily overcome but from memory didn't use to be though I stand to be corrected on that, it is 10 years after all.
I've had a look at the Options but couldn't find anything there to help.
Any clues on what is going on?
2013-07-12, 11:30 #2
- Join Date
- Dec 2009
- Oxfordshire, UK
- Thanked 153 Times in 146 Posts
This link is about the specific problem - http://windowssecrets.com/forums/sho...-to-%27Like%27
And on this forum - see http://windowssecrets.com/forums/sho...-to-%27Like%27
Last edited by access-mdb; 2013-07-12 at 11:32.