>Hi Jim,
>so nice to hear from You
>>
>>Try this;
>>
>>findtext = "%" + thisform.txtsearch.value + "%"
>>select * from task;
>>where description LIKE findtext
>
> can't work because 'findtext' is a parameter to the SQL statement.
> where description LIKE (findtext) && will do
>
> best regards from Friedrichsdorf
> see You in September?
> Eugen
Hi there,
Sorry I got this CC and I also said this would work. I couldn't understand why it can't work. Yes, it's a parameter to SQL and legal. I say :
If thisform.txtsearch.value is processed (ie:it needs alltrim(), upper()) this will work as also your suggestion will. ie:
findtext = "%" + thisform.txtsearch.value + "%"
select * from (home()+"samples\data\customer") ;
where contact LIKE findtext
Would return contact names containing "na". What am I missing ?
Cetin