>I am using a SQL-LIKE with the percent wild cards. Findtext is a variable. This select statment does not work. Does anyone know why?
>Is there another way to do the same thing?
>
>findtext = thisform.txtsearch.value
>select * from task;
>where description LIKE %findtext%
>
>Thanks
>
>Jim
It would be "%"+findtext+"%" and do not forget alltrim(thisform.txtsearch.value) otherwise generally you wouldn't find anything.
Cetin