Re: Varchar concatenate fields as Char or Varchar, not Text

[MargaretGillon@xxxxxxxxxxxxxx]

>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