>What happens is that suddenly the foll line will give an error:
>
>IF ALLTRIM(STR(gcProduct)) == "WASTE"
>
>Will give us an error as though the value of gcProduct is no longer a string.

If gcProduct is a string, why are you calling the STR function. You may want to use UPPER(ALLTRIM(gcProduct))

Tom Molloy