Sergey,

I didn't realize that.

Thanks again.

>David,
>
>>As far as the iciwhs.citemno+iciwhs.cwarehouse= sostrs.citemno+sostrs.cwarehouse is concerned, the compiler doesn't complain about it, and it runs. SQL Server seems to support the + operator in the statement. I haven't tested to make sure it returns the same results as doing it as:
>>iciwhs.citemno = sostrs.citemno AND iciwhs.cwarehouse= sostrs.cwarehouse
>>
>>but I'll check. Am I confused here? Shouldn't these statements be equivalent?
>
>They would produce the same result set but in the second case SQL Server could use indexes to optimize query.