Problem with WildCard

[ikabob]

ok in access 2003 i have tried everything to get the Like "*oak*" to work but to all fail it replaces "Like" with "ALike" i have tried to find some info on this but have not it seams like something easy i wanted to do.

SELECT MainData.ModelName
FROM MainData
WHERE (((MainData.ModelName) ALike "*oak*"));

some reason it wont find all data with "oak" in it just returns empty

this is like query 101 but for some reason it has stumped me, along with one other problem but i am still researching that one.

 

[ikabob]

Nope still did not work.. i am going crazy over this thing

 

[Bob Scarborough]

Your have formating problems. This works for me in a query so modify yours to resemble same with the sqare ([) brackets.

SELECT [Combined Data].Description
FROM [Combined Data]
WHERE ((([Combined Data].Description) Like "*PVC*"));

 

[ikabob]

ok i do not know what this is doing cause it will not take at all if it is not exzact it will not do it..

and the part where it changes "Like" to "ALike" is getting very annoying.

i have tried all the above plus other stuff with no luck even tried other fields just in case this Field had bad data still no luck

 

[ikabob]

I AM an idiot ... its


SELECT MainData.ModelName
FROM MainData
WHERE (((MainData.ModelName) ALike "%oak%"));

thanks all for racking your brains for me

 

[Psilokan]

lol

I was just about to sugges that you try % instead of *

Little inconsistancies between DBMSes like that drive me nuts.