> 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 ? Many thanks for your help -- ----- Graeme Hinchliffe (BSc) Core Internet Systems Designer Zen Internet (http://www.zen.co.uk/) Direct: 0845 058 9074 Main : 0845 058 9000 Fax : 0845 058 9005 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
