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

Nevermind. The plus sign is what works. The actual problem was I could not distinguish between a lower case "L" and the letter "I" in a field name in the Enterprise Manager Table properties sheet. Small non-adjustable fonts are hell when one gets "older".