like operator 1

[jshanoo]

Hi,
I have this following query as follows:
----------------------
SELECT Contract.ContractID, Contract.ClientName, Contract.Phone, Contract.contractDt
FROM Contract
Where trim(phone) = '888%'
-----------------------
there are records starting with 8888

but the when i am firing the query it is retruning only zero records

can please tell me where the problem is ?


thanks john


*** Even the Best, did the Bad and Made the Best ***

John Philip

 

[swampBoogie]

SELECT Contract.ContractID, Contract.ClientName, Contract.Phone, Contract.contractDt
FROM Contract
Where trim(phone) like '888%'

if you are using the Jet OleDB provider

SELECT Contract.ContractID, Contract.ClientName, Contract.Phone, Contract.contractDt
FROM Contract
Where trim(phone) like '888*'

if you are using the access driver

 

[jshanoo]

Thanks Boogie
It worked

John

*** Even the Best, did the Bad and Made the Best ***

John Philip