Is it possible that the statement retrieving the value from the table does not actually return a row..? This would make the variable NULL.

As the other posts have said, we are happy to help if you post your code. 😉