Stuart McLachlan
stuart at lexacorp.com.pg
Sat Jan 31 19:59:23 CST 2004
On 31 Jan 2004 at 20:44, John W. Colby wrote: > In Access I often do things in queries like: [LastName] & ", " & [FirstName] > > This appears to be bad syntax in SQL Server. Is there an equivalent? > Lastname + ', ' + FirstName Text delimiters are single quotes. String concatenation uses "+". "&" performs an AND logical bitwise comparison. -- Lexacorp Ltd http://www.lexacorp.com.pg Information Technology Consultancy, Software Development,System Support.