> 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
>
Greg,

The wildcard character for ISQL is '%', not '*'.  Try changing your SELECT to:

SELECT name,city FROM mydatabase.mydataset WHERE name LIKE 'A%';

Good luck!

Dave



David Hopfensperger, Systems Analyst
State Farm Insurance, Bloomington, IL
email:  [log in to unmask]