[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.