Hello,

sorry if it is not the good NG.

I have a little problem concerning querying a paradox 7 (yes tou read
weel) db via php and odbc.
For this I use the microsoft paradox driver, the only one I have.

I have the following computers:
- S1 w2k server
- S2 2003 server, over a vmware
- P1 xp sp2

all running apache 2.0.59 and php 5.2.1

please consider the following queries and their results on the different
computers:

select Code from corrcli where Code like 'faur%'
S1: nothing
S2: a list of codes beginning by FAUR
P1: nothing

select Code from corrcli where Code like 'FAUR%'
S1, S2: the same list of codes beginning by FAUR
P1: nothing

select Code from corrcli where Code like '%FAUR%'
S1, S2, P1: the same list of codes comprising FAUR

well...

how to fixe this behaviour ? If the answer is:" change the driver...",
for which one (free if possible).

thanks in advance

thierry