[AccessD] Re: SQL Server queries - appending strings

John,

LastName + ', ' + FirstName

SQL Server uses single quotes and + instead of &

Robert

At 10:18 AM 2/1/2004 -0600, you wrote:
>From: "John W. Colby" <jwcolby at colbyconsulting.com>
>Subject: [AccessD] SQL Server queries - appending strings
>To: "SQLServer" <dba-sqlserver at databaseadvisors.com>,   "AccessD"
>         <AccessD at databaseadvisors.com>
>Message-ID: <DCEFJAOENMNENLAAOFGPGEDIGJAA.jwcolby at colbyconsulting.com>
>Content-Type: text/plain;       charset="iso-8859-1"
>
>In Access I often do things in queries like: [LastName] & ", " & [FirstName]
>
>This appears to be bad syntax in SQL Server.  Is there an equivalent?
>
>John W. Colby