SELECT * FROM MyTable WHERE IDUSE == ("FAX" + CODE)

HTH

>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!!