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 could use coalesce(var1,'') || coalesce(var2,'')
Or, wrap that in your own function and create your own operator.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
