> 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