Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL PT returns a CAST AS CHAR(100) as memo, need char fl
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Re: SQL PT returns a CAST AS CHAR(100) as memo, need char fl
Environment versions
Visual FoxPro:
VFP 9 SP1
Database:
MS SQL Server
Miscellaneous
Thread ID:
01178491
Message ID:
01178789
Views:
20
Hi Jim

Thanks for your response.

>I have found this to wokr for me;
>
>
>SELECT ..., SUBSTRING(Remarks,1,100) AS cRemarks ...
>
Yes, I did try this out too, but somehow something is wrong on my side and it does not seem to convert to a character field.
Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://venussoftop.tripod.com
___________________________________________
venussoftop@gmail.com
___________________________________________
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform