Combining Columns

[=?Utf-8?B?Qm9iYnlQUzI4MDU=?=]

How can you combine the information in two columns to one?

Column A is first name
Column B is last name

I need there to be one column with both first and last name.
(There is roughly 300K rows)

[breitak67]

Re: Combining Columns


SELECT A + ' ' + B as fullname
FROM mytablename

This returns the data to your app with the two fields combined with a
space separator. Last name first is:

SELECT B + ', ' + A as fullname
FROM mytablename


--
breitak67