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