DSXchange

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

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.

Thank you chulett, got it