Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 612A0476D62 for ; Thu, 5 Sep 2002 18:15:04 -0400 (EDT) Received: from news.hub.org (news.hub.org [64.49.215.80]) by postgresql.org (Postfix) with ESMTP id BD793476D64 for ; Thu, 5 Sep 2002 18:15:01 -0400 (EDT) Received: by news.hub.org (Postfix, from userid 8) id CEF80381BD9; Thu, 5 Sep 2002 18:15:00 -0400 (EDT) From: "Linn Kubler" X-Newsgroups: comp.databases.postgresql.sql Subject: Character translation? Date: Thu, 5 Sep 2002 17:15:02 -0500 Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 28 Message-ID: X-Complaints-To: news@hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4807.1700 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300 To: pgsql-sql@postgresql.org X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/40 X-Sequence-Number: 9317 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.