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 |
|
jcb267
Constraint Violating Yak Guru
291 Posts |
 Posted - 2011-01-03 : 22:10:04
|
| Hi - I am trying to concatenate 3 fields, a date, a number and a text field but dont know how to convert the fields. Can anyone help me? |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-01-03 : 22:46:00
|
| Have a look at the convert function in bol.convert(varchar(8),datefield,112) + ' ' + convert(varchar(20),intfield) + ' ' + textfield==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
jcb267
Constraint Violating Yak Guru
291 Posts |
Posted - 2011-01-04 : 15:31:03
|
| Thanks! |
|
|
|
|
|
|
Concatenation