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 |
|
slvfox
Starting Member
2 Posts |
 Posted - 2009-11-11 : 11:13:49
|
| Hi All,I'm trying to set up a computed column of the form Col A(int) + ' ' + Col B(nvarchar(50)) with the resulting column as an nvarchar()computed column. I'm not having much luck with either the designer or T-SQL.The docs seemed to suggest the the int conversion was handled automatically, but the resultant column is a string.Any help is appreciated.Slvfox |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-11-11 : 11:19:04
|
try:convert(nvarchar(50),ColA)+' '+ColB
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
slvfox
Starting Member
2 Posts |
Posted - 2009-11-11 : 11:32:55
|
| Worked like a charm WebFred.Thanks muchSlvfox |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-11-11 : 11:33:26
|
welcome 
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
Computed Columns