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

[MargaretGillon@xxxxxxxxxxxxxx]

Rodrigo Gonzalez <rjgonzale@xxxxxxxxx> 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