I am having problems doing what seems to be a very simple thing. All I
need is to join 2 or more variables (eg char, int, date) and return them
as a single varchar variable.
eg ret := int + char + date; or better still join("+", int,char,date)
return ret;
some additional info. I have read in the documentation that you can
concat with the || operator. However because one or more of the
variables may be empty this seems not to work. If one of the variables
is empty nothing is returned.
Please can anyone help.
Thanks in advance David Mulcahy.