Using MSAccess you can use an SQL command like:
'SELECT name,city FROM mydatabase.mydataset WHERE name LIKE 'A*';'
(50 records were selected).

When I used the same command in ISQL, no records were selected.
Thanks
Greg