[AccessD] SQL Server queries - appending strings

Sat Jan 31 22:03:24 CST 2004

John,

Lose the brackets and substitute  + for & and ' for ".

Jim

----- Original Message ----- 
From: "John W. Colby" <jwcolby at colbyconsulting.com>
To: "SQLServer" <dba-sqlserver at databaseadvisors.com>; "AccessD"
<AccessD at databaseadvisors.com>
Sent: Saturday, January 31, 2004 5:44 PM
Subject: [AccessD] SQL Server queries - appending strings


> 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
> www.ColbyConsulting.com
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>