paul 17028 (5/6/2015)
HiThanks for replies. removing the wildcards was the first thing I tried but this resulted in "no records found" which is strange because i have other statements without the wildcards and they work fine.
I have been looking around and I have found this "collate Latin1_General_CI_AS" but I have bean unable to implement it if it is at all possible.
Could it be the way i am adding the data to the N_image_desc field in access? I have it with a comma and a space like this. I have noticed that I have some spaces before the comma in some cases would this make a difference?
woman, woman , beach , sea , seaside , figure, figurative , dress , romantic , coast , waves , sun , sunshine
Thankyou
Wait a minute. Are you saying that one of your columns contains comma delimited values? That is why you would need the wildcards both leading and trailing. It is also why you are going to get false matches like you found. This is because you have violated 1NF by putting multiple values in a single table intersection. I don't know what to tell you that might work with Access other than to move these values to a properly normalized table.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/