Re: [SQL] String Concatnation

[Brett W. McCoy]

On Sat, 10 Feb 2001, Najm Hashmi wrote:

>  How can I concatnate   two varialbles, seperated by a |,  that are type text
> together?
> v, v1 text;
> some work
> then
> res:= v ||''|''|| v1;

What error is it giving?  Do you need to be using two single quotes in the
statement?

-- Brett
                                     http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
There is a certain impertinence in allowing oneself to be burned for an opinion.
                -- Anatole France