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