Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Combining Fields

Author  Topic 

bulubuk1976
Starting Member

24 Posts

Posted - 2008-03-20 : 02:32:39
How do you combine ntext fields? I can combine nvarchar by this example: Position1 +', '+ Position2 AS Positions

Is there a way to combine ntext? Thanks!

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2008-03-20 : 06:52:12
do you mean just to display it or do you want to put it all into 1 column?

how about casting them as varchar(max)? or look at UPDATETEXT in Books Online

Em
Go to Top of Page
   

- Advertisement -