request with spaces

[angiras]

I get my SQL request in the query string :

?Affectation='%me%20HEBER%'

for : anyField LIKE '%me HERBER%'

sometimes I get the right values sometimes not

do you know why ?

[MAK]

because URL cannot accept blank spaces.

you have to use replace() function to remove %20

[angiras]

I of course I have think to it , but in that case : why does it works in 90% of the cases ?

thank you for helping

[angiras]

I have tested directly in Access and a few request with spaces return nothing

Model LIKE '*AS nt*'

sometimes it works with spaces sometimes not ....