If I concatenate 2 fields:
SELECT field1||'-'||field2 FROM table1,
I get NULL if one of the fields is NULL.
Is this normal? How can I blank NULL fields on SELECT so that on concatenation, I see the ones that are defined?
I cannot do this in the database because some of them are foreign unique keys
Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________ hsqldb-developers mailing list hsqldb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
