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...)