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

[MargaretGillon]

Rodrigo Gonzalez <[EMAIL PROTECTED]> wrote on 08/07/2006 11:41:52 AM:

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

This worked, thank you.
*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***
Margaret Gillon, IS Dept., Chromalloy Los Angeles, ext. 297