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 |
|
tpiazza55
Posting Yak Master
162 Posts |
 Posted - 2007-02-27 : 09:44:00
|
| (COALESCE (MaterialNumber, '') + ' - ' + COALESCE (MaterialName, '') )AS materialDescriptionI get an error saying cant covert varchar topsoil to type integermaterialnumber = number or nullmaterialname = namehow do i get 100 - Dirt - Top Soil |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-02-27 : 09:45:41
|
| COALESCE (Convert(varchar(20), MaterialNumber), '')Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-02-27 : 09:46:10
|
[code](COALESCE (MaterialNumber, '') + ' - ' + COALESCE (convert(varchar(10), MaterialName), '') )AS materialDescription[/code]
KH |
|
|
|
tpiazza55
Posting Yak Master
162 Posts |
Posted - 2007-02-27 : 09:56:27
|
| thanks |
|
|
|
|
|
|
COALESCE error