Database null returning as string null in soap xml

Question

I'm using Livecycle for a web service tier.

If there is a null in the database, the nodes have a string 'null' in them.

how can I make sure that I strip out the 'null' values form the nodes and also tell if the value of the node is really 'null'?

Answer 1

IsNull('','') is added to the SQL. That way the database catches the true db null and makes it a blank.