DSXchange

i'm trying to use the IsNull on the stage variables ,it is giving the compiling error,

is there any thing i can use to do the isNull on stage variables.





Thanks

You should be able to use IsNull() on stage variables. Post the compilation error you are getting, that might say more to investigate.

If you have a stage variable var1 you can have an expression like this,

If IsNull(col1) then ...

But you have another stage variable var2 you [u]cannot [/u]have an expression like

If IsNull(var1)

Righlty said. You can use IsNull() or IsNotNull(), say any Null Handling functions in a stage variable. But the input to these functions cannot be a stage variable, regardless of where you are using these funtions.