Access 2007 Database Select Query

[Christopher McGee]

When Conducting an Access Select Query through Automation Anywhere I'm not getting any results when I use the "Like" Expression. But when I conduct the same query in Access I get results.

Below is an Example of my SQL Query.

SELECT Cameras.StoreNumber, Cameras.CameraName, Cameras.SiteName
FROM Cameras
WHERE (((Cameras.SiteName) Like "*TOP 10*"));

Any help is greatly appreciated.

Thanks,
Chris.

[forumsupport]

Hello,

Try using '%' instead of '*', it should work.

We have attached sample for reference. To run this sample,

. Please copy .atmn under location, 'C:\...\My Documents\Automation Anywhere\Automation Anywhere\My Tasks' folder.
. Copy .mdb under C:\.

Hope that helps.

[trentonponder]

Instead of *top ten* use %top ten%