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 |
|
sqllearner05
Starting Member
9 Posts |
 Posted - 2012-07-19 : 01:42:37
|
| i have a value of column as null from txt file, if null i want to replace it with 0 if not same value, but the problem is value coming from txt is null and i want to put 0 in table having data type int, please suggest me what expression should i give in derived column transformation.thanks in advancesqllearner |
|
|
jleitao
Posting Yak Master
100 Posts |
Posted - 2012-07-19 : 05:50:41
|
| ISNULL ([column]) ? 0 :[column] |
 |
|
|
jleitao
Posting Yak Master
100 Posts |
Posted - 2012-07-19 : 05:52:50
|
| Or if you recive "Null" as text:[column] == "NULL" ? 0 : [column] |
|
|
|
|
|
|
how to replace null values