Clay Passick
Clay.Passick at minneapolis.edu
Mon Feb 2 09:04:51 CST 2004
[lastname]+', '+[firstname] should work Clay Passick D.B.A. MCTC 1501 Hennepin Avenue Minneapolis, MN 55403 612.659.6615 >>> jwcolby at colbyconsulting.com 1/31/2004 7:44:31 PM >>> 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