By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,963 Members | 1,279 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,963 IT Pros & Developers. It's quick & easy.

Using Like on a MEMO field

P: 3
I have read many posts on this, and it says it is possible. For some reason I cannot figure it out.

I am in Access 2003 SP3

Query i am using

select *
from aotw_application
where aotw_num LIKE "*application*"

I get no records returned. I know that application is in the memo fields and should return mulitple results.

Thanks fro your help in advance. this is driving me nuts.
Oct 26 '06 #1
Share this Question
Share on Google+
3 Replies

P: 3
Sorry, should be

select *
from aotw_application
where application LIKE "*application*"
Oct 26 '06 #2

P: 3
wow, sorry everyone. i have just been looking at this too much

that was the fix. change the freakin where clause.

wow, it has been a long day and its only noon.
Oct 26 '06 #3

Expert Mod 15k+
P: 31,347
Hey, An Author answered post isn't a BAD thing ;-)
Oct 26 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.