whats wrong with this sql ::
select * from DTDC_Service_Offices where city like 'A*' order by city, branchname

in MS Access its resulting in 30 records but when fired from VB its returning 0 records, is there any problem with the * sign or what is it ? can't figure it out.
thanx