Re: SQL ADD THREE FIELDS INTO OTHER FIELS

From: Hugo Kornelis <hugo@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Wed, 08 Mar 2006 22:52:42 +0100

On Wed, 8 Mar 2006 03:32:28 -0800, TYE wrote:

Hi,

i have three fields that are title, firstname and surname,

i want to add all three field together in a different field,

How can this be done

Hi TYE,

ALTER TABLE YourTable
ADD ConcatField AS Title + FirstName + Surname

But you could also consider just concatenating them in a view, in your
query or on the client.

--
Hugo Kornelis, SQL Server MVP
.

Prev by Date: [OT] User-Defined string Functions MS SQL Server 2005 Transact-SQL
Next by Date: Re: Using wildcard criteria in an 'in' statement
Previous by thread: [OT] User-Defined string Functions MS SQL Server 2005 Transact-SQL
Next by thread: Re: Using wildcard criteria in an 'in' statement
Index(es):
- Date
- Thread

Relevant Pages

Re: Character in SQL
... Aaron Bertrand ... SQL Server MVP ... "J P Singh" wrote in message ... > We have an application which uses surname and the date of birth to allow ...
(microsoft.public.inetserver.asp.general)
RE: multiple ORDER BY clauses?
... surname, firstname, company ... If the Company column is a company name then you should consider putting it ... David Portas ... SQL Server MVP ...
(microsoft.public.sqlserver.programming)