Access query works fine unless is executed from VB application

[dafi]

the query looks like this:

SELECT calls_listing.dialnumber
FROM calls_listing
WHERE (Len(Trim(calls_listing!dialnumber)) In (10,11)) And ((calls_listing!dialnumber) Like ('072*'));


in Access where i wrote the query it executes fine.
in VB where i have to use it returns no rows !!!!

 

[simco]

What do you want to do with Like ('072*'). If you want all the phone numbers that start with 072, than this syntax is wrong (is looking for phone numbers equal to 072*).

 

[OldKrot]

See if you want to use syntax 'Like' youi need to wright only chars that you need what does it mean
Like ('072*') mean that you want all numbers where you have
072*
Ok?