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 |
|
chipembele
Posting Yak Master
106 Posts |
 Posted - 2014-03-07 : 08:43:33
|
| HiI'm wanting to concatenate something that doesnt exist to an already existing field.What I need to do is add a generic email address to every record in a data viewSo, what it would do is take the column that does exist and add @domain.com to another column that I would call usernameSo rather than it just appearing as 911234 it would be a derived column saying 911234@domain.com i've tried using +''+ but I get a space after the numberCan you help please? |
|
|
MIK_2008
Master Smack Fu Yak Hacker
1054 Posts |
Posted - 2014-03-07 : 09:32:45
|
| Post the sql query you've used, along with its output and the issue that is in the output.CheersMIK |
 |
|
|
chipembele
Posting Yak Master
106 Posts |
Posted - 2014-03-07 : 10:45:02
|
| HiI sorted it now thanks. One of the fields didnt support what I was trying to do |
|
|
|
|
|
|
Concatenating Text In a Query