Hi All,
I have a condition If IsNull(DSLink1.EMP_ID) Then ' ' Else DSLink1.EMP_ID
Now iam confused when to use @NULL , Can we use @ NULL instead of ' ' in the condition .
Please suggest me.
Thanks in advance
@NULL
Moderators: chulett, rschirm, roy
No. That derivation is testing for null and when it is null is setting the output to a single space. Also, there's no reason to do any kind of a test if the input should be passed along unchanged, null or otherwise, which is what your proposed modification would (in effect) do.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers