Re: [Hsqldb-developers] Funny SELECT Question

Hello Clayton, The HSQLDB has a number of built-in functions. Please check out the documentation. It seems like you need one of two functions: IFNULL(exp,value) if exp is null, value is returned else exp) COALESCE(expr1,expr2,expr3,...)[2 ]

[Hsqldb-developers] Funny SELECT Question

Being a little new to SQL, I have a question that I'm having a hard time answering. I have created a master/detail desktop application using HSQL to handle farm and garden crop planning. Since a number of different crops might have very similar characteristics and only vary in a few details, I wa