Re: [GENERAL] Varchar concatenate fields as Char or Varchar, not Text

[MargaretGillon]

>Rodrigo Gonzalez <[EMAIL PROTECTED]> 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