How to join 2 fields in one field
		Date: 04/25/06 
		(SQL Server)    Keywords: no keywords
Hi!
I have 2 tables. 
First table has 2 fields:
FIRST NAME  LAST NAME  
I need to copy data to new table, but new table has only one field:
CLIENT NAME
How can I copy data?
Thank you,
Elena.
Source: http://community.livejournal.com/sqlserver/47332.html