Page 1 of 1

How to populate NULL?

Posted: Mon Sep 06, 2010 10:06 pm
by synsog
Hi..

My column datatype is decimal. so can you please let me know how to populate null for that coumn. If i use setnull() then , all the 0 values are also populating as null.

Please reply


Thanks

Posted: Mon Sep 06, 2010 11:01 pm
by ray.wurlod
What is your target?

What is your derivation expression?
(For example, setnull() alone will only and always set NULL - you need conditional logic that specifies when NULL should be set.)