Concatenation—SQL Server 7 didn’t support the ANSI || method of concatenation, but SQL Server 2000 does. Both can use a plus (+) character to indicate concatenation, but it should be reserved ...