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