>>What is the correct to concatenate 2 character fields in a sub-query for SQL Server? I have tried the plus sign, a comma and the double-pipes (Oracle equivalent). TIA!

>>SELECT * FROM SQLTable WHERE
>>   CField1, cField2 IN
>>   (select CField1, cField2 from SQLTable2
>>    WHERE...)

>
>

>SELECT st1.* FROM SQLTable st1
>  JOIN SQLTable2 st2
>    ON st1.CField1 = st2.CField1
>      AND st1.CField2 = st2.CField2
>      AND  <WHERE clause for st2 here>

Even better. I did not realize SQL Server allowed that type (JOIN) of syntax.