I am getting an error when trying to compare a varchar value to a numeric value. My question is there a what to force the varchar value to a defalut numeric value? For example, if the value is "Misc" I would like that value to default to 9999 which in the Join table does exist as an "Unknown" code. And if the value is '123' this is a valid number in the Join table and should be found.
Thanks for the assistance.