[AccessD] RE: [dba-SQLServer]SQL Server queries - appending strings

Billy Pang tuxedo_man at hotmail.com
Sun Feb 1 01:05:03 CST 2004


SELECT LASTNAME + ', ' + FIRSTNAME from employees...........


HTH
Billy

>From: "John W. Colby" <jwcolby at colbyconsulting.com>
>Reply-To: dba-sqlserver at databaseadvisors.com
>To: "SQLServer" <dba-sqlserver at databaseadvisors.com>,   "AccessD" 
><AccessD at databaseadvisors.com>
>Subject: [dba-SQLServer]SQL Server queries - appending strings
>Date: Sat, 31 Jan 2004 20:44:31 -0500
>
>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
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>

_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online  
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com



More information about the AccessD mailing list