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.
| Author |
Topic |
|
ashangel
Starting Member
3 Posts |
 Posted - 2002-04-30 : 01:19:25
|
| how do i reconstruct multiple(two/more) recordset.fields into a single field and add hardcoded text for the result..eg:tb_userfirstname lastname--------------------george bushosama laden..taking cue from original sql statement "select firstname,lastname from tb_user" i would like to see instead of getting rs.fields(0),rs.fields(1) manually.1-i want to do for each rs, rs.fields(0) and get something like"george so bush""osama so laden" from a single rs.fields column.2-plus with "so" hardcoded in between (so - stands for son of)thanks in advance |
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2002-04-30 : 01:30:06
|
Select FirstName + ' so ' + LastName as Name from tb_User DavidMTomorrow is the same day as Today was the day before. |
 |
|
|
ashangel
Starting Member
3 Posts |
Posted - 2002-04-30 : 01:40:09
|
| thanks for the reply. |
|
|
|
|
|
|
reconstructing recordset