Message-Id: <200209090747.g897loST003822@tksoft.com>
Subject: Re: Character translation?
To: lkubler@ecw2.org (Linn Kubler)
Date: Mon, 9 Sep 2002 00:47:49 -0700 (PDT)
Cc: pgsql-sql@postgresql.org
Reply-To: tjk@tksoft.com (Troy K.), <tjk@tksoft.com>
In-Reply-To: <no.id> from "Linn Kubler" at Sep 05, 2002 05:15:02 PM
From: "Troy" <tjk@tksoft.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Would this work?

select recid, title, firstname || chr(32) || lastname::char(50) as expert, 
	rank from mytable where length(lastname) <= 50;


Troy

> 
> Hi,
> 
> I have a view like this:
> create view myview as
> select recid, title, firstname || chr(32) || lastname as expert, rank
>   from mytable;
> 
> When I use this view via odbc on a Windows 2000 system using Visual FoxPro
> the expert field shows up as a memo field.  This is analogous to the text
> field in PSQL.
> 
> What I'd like to do is have the expert column come through as a varchar type
> so that it shows up as a text field in VFP.  Any suggestions?
> 
> I was looking at the functions and didn't see anything that would do the
> trick for me but I could have just missed something.  I also saw a reference
> to the cast() function but couldn't find any usage info on it in the online
> docs.
> 
> Any help is greatly appreciated.
> Thanks in advance,
> Linn
> 
> 
> --
> Please remove the number two from domain name for email.
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>