| Author |
Combining three text fields
|
|
|
| I am trying to combine three text fields into one field. This is a basic
procedure I know but I cannot find help on the SQL Server 2000 SP4 online
help. I think I am calling the procedure wrong.
I want to combine the First_Name, Middle_name, and Last_Name into one
column. Currently they are in three different columns.
Does anyone have a query that will do this?
Thanks from a Veteran and a beginning SQL Server User.
--
Ray
| |
|
|
| Adam Machanic 2005-11-09, 8:24 pm |
| I think you've made a mistake in defining your data types. TEXT is a
large-object datatype; it should be used for data > 8000 bytes. For smaller
data such as names, you'll want to stick with VARCHAR.
--
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Ray" <ray.smith@loislaw.com> wrote in message
news:6752D1E3-B740-44B2-B867- AB0C037DC726@microso
ft.com...
>I am trying to combine three text fields into one field. This is a basic
> procedure I know but I cannot find help on the SQL Server 2000 SP4 online
> help. I think I am calling the procedure wrong.
>
> I want to combine the First_Name, Middle_name, and Last_Name into one
> column. Currently they are in three different columns.
>
> Does anyone have a query that will do this?
>
> Thanks from a Veteran and a beginning SQL Server User.
> --
> Ray
| |
|
| Thank you very much. That is exactly what I needed.
When I look that up in help what would I look for?
--
Ray
"SQL" wrote:
> select First_Name + Middle_name+ Last_Name as FullName
> from table
>
> http://sqlservercode.blogspot.com/
>
>
| |
| Raymond D'Anjou 2005-11-10, 9:23 am |
| String Concatenation Operator
"Ray" <ray.smith@loislaw.com> wrote in message
news:577C1B18-4465-481F-9752- BABD4BE81CB5@microso
ft.com...[color=darkred]
> Thank you very much. That is exactly what I needed.
>
> When I look that up in help what would I look for?
> --
> Ray
>
>
> "SQL" wrote:
>
|
|
|
|