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 |
|
reddymade
Posting Yak Master
165 Posts |
 Posted - 2006-06-01 : 10:17:35
|
| I am trying to use the following query: getting an invalid operator error: both the columns are nvarchar datatype:SELECT ContractNO + '' - '' + ContractName AS bodyFROM TAB_ccsNetContractsCan you please tell me what am i doing wrong.Thank you very much for the info. |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-06-01 : 10:22:06
|
| SELECT ContractNO + ' - ' + ContractName AS bodyFROM TAB_ccsNetContractsMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
select query with concatenation help