On Thu, 30 Sep 2004, Graeme Hinchliffe wrote: > > If monthcurr or username are null, the above will be null. > > Anything || NULL => NULL. > > AH! thanks sorted it now. That is not the behaviour I would have > expected :) > > Is there a concatination operator that will not do this? IE > > if > > var1 || var2 || var3 > > and var2 is null would result in just var1var3 ?
You can use coalesce as suggested... However, since you are building a statement, think about what you want to do when either of those are NULL. You might want to use an empty string, or perhaps instead of ='' you might actually be wanting an IS NULL clause, etc... ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
