Re: Varchar concatenate fields as Char or Varchar, not

[Rodrigo Gonzalez <rjgonzale@xxxxxxxxx>]

SELECT b.ltname, ((c.refullname::text || d.enname::text) || 
f.evname::text)::varchar AS evlinkname1,

MargaretGillon@xxxxxxxxxxxxxx wrote:
> >Rodrigo Gonzalez <rjgonzale@xxxxxxxxx> wrote on 08/07/2006 11:36:28 AM:
> > Really, I dont see the 3 varchar fields concatenated to a new field.
> >
> > But do this....
> >
> > (varchar1||varchar2||varchar3||newfield)::varchar
> >
> > Best regards
> >
>
> This is the concatenate statement
>
> > > SELECT b.ltname, (c.refullname::text || d.enname::text) ||
> > > f.evname::text AS evlinkname1,
>
> Margaret Gillon