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 |
|
krish001
Yak Posting Veteran
61 Posts |
 Posted - 2010-03-30 : 12:04:44
|
| Iam joining two columns where one column is having data and other coloumn is not having data so it is not joining how can i solve this such that i can get one column with data other coloumn with NULLPlz help |
|
|
DBA in the making
Aged Yak Warrior
638 Posts |
Posted - 2010-03-30 : 12:16:33
|
| To concatenate Column1 and Column2, where Column2 sometimes contains NULL:[code]SELECT Column1 + ISNULL(Column2, '')FROM ...[\code]There are 10 types of people in the world, those that understand binary, and those that don't. |
 |
|
|
|
|
|
Query help