SQL question

[John Bailo]

Is there a way to select a whole row of fields as a single string?

Such as:

SELECT * AS [WHOLESTRING] From mydb.dbo.mytable

?

 

[PhilipDaniels]

Is there a way to select a whole row of fields as a single string?

Such as:

SELECT * AS [WHOLESTRING] From mydb.dbo.mytable

?

You can concatenate fields together in SQL:

SELECT colA + ';' + colB FROM myTable

Of course you will have to cast everything to a character type for
this to work. But why would you want to do this?