>HI Nick,
>When I do it, I do not get any rows.
>
>Thank you for your help,
>Christian
Hi Christian,
PMFJI, but try using:
lcvalue = ALLTRIM(ThisForm.TxtAddress.Value)
SELECT Company, Address FROM Companies WHERE ALLTRIM(Address) == lcvalue INTO CURSOR MyCursor
Note the ==. This will be an exact match.
As Nick mentioned, you'll get much better performance by evaluating the vaiable once rather than for every row.
hth,
George
Ubi caritas et amor, deus ibi est