At 13/05/2002 04:45 PM, you wrote:

> > select a + ';' b + ';' c
>
> > s=:a+';'+b+';'+'c';
>
> > Any clues?
> >
> >
>Maybe you should try
>
>select a||';'||b||';'||c
>
>or s=:a||';'||:b||';'||:c;

Also, if one of the strings is null, the result will be null.


Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)