MSAccess Query Problem using LIKE

[M Riaz Bashir]

Hi, Kindly let me know that, How may I use following Oracle Query into MSACCESS ? SELECT PCODE,PNAME FROM PRODUCT WHERE PNAME LIKE('%APPLE%') Thank you in Advance (Riaz)

[Jorgen Andersson]

Try exchanging the "%" for "*".

[puviyarasan j]

You can use * instead of %.

[Niladri_Biswas]

Hi man, In Ms Access, it can be achieved by SELECT PCODE,PNAME FROM PRODUCT WHERE PNAME LIKE('*APPLE*') Just replace '%' sign by '*' sign Hope this helps :)

Niladri Biswas