Try
lcStr = "FAX"
SELECT * FROM mytable ;
WHERE iduse = lcStr + code ;
INTO CURSOR crsResult
>Hello,
>I have a table like following:
>
>
>CODE|IDUSE |
>---------------
>A |FAXA |
>V |FAXB |
>A |FAXC |
>---------------
>
>
>What I want is to run a select statement on this table that finds when the IDUSE matches FAX(which I will be supplying through code)+CODE (so the only one that would correctly show is FAXA). Sorry if I didn't explain this very well... but any help would be greatly appreciated. Thanks!!
>
>MAC
--sb--