Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 023A047640F for ; Mon, 9 Sep 2002 11:43:21 -0400 (EDT) Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178]) by postgresql.org (Postfix) with ESMTP id 6986547611B for ; Mon, 9 Sep 2002 11:37:37 -0400 (EDT) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 6E4E4D602; Mon, 9 Sep 2002 08:37:37 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 63F315C03; Mon, 9 Sep 2002 08:37:37 -0700 (PDT) Date: Mon, 9 Sep 2002 08:37:37 -0700 (PDT) From: Stephan Szabo To: Linn Kubler Cc: Subject: Re: Character translation? In-Reply-To: Message-ID: <20020909083627.P13345-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/52 X-Sequence-Number: 9329 On Thu, 5 Sep 2002, Linn Kubler wrote: > 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. cast() isn't a function precisely speaking. It works as CAST(expr as datatype).