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 [EMAIL PROTECTED]
