J John Bailo Feb 21, 2007 #1 Is there a way to select a whole row of fields as a single string? Such as: SELECT * AS [WHOLESTRING] From mydb.dbo.mytable ?
Is there a way to select a whole row of fields as a single string? Such as: SELECT * AS [WHOLESTRING] From mydb.dbo.mytable ?
P PhilipDaniels Feb 21, 2007 #2 Is there a way to select a whole row of fields as a single string? Such as: SELECT * AS [WHOLESTRING] From mydb.dbo.mytable ? Click to expand... 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?
Is there a way to select a whole row of fields as a single string? Such as: SELECT * AS [WHOLESTRING] From mydb.dbo.mytable ? Click to expand... 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?
