Handling nulls in Java

When using Oracle, I use the decode funvtion to do it.

select decode(a, null, ' ', a), b, c from t1 where d = 10;

The first column in the selected resultset will be a space if the database column in null.

Is that what you wanted ?

I am not aware whether decode is part of standard SQL though.

neville_sequeira at 2007-6-29 12:03:23 >

>...from a Database to maybe something like a space

That might not be a good idea.

Doing that means that when you put data back into the database you must trim every value and then check to see if it is an empty string. If it is empty then you have to set the field to null.

jschell at 2007-6-29 12:03:23 >