Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL PT returns a CAST AS CHAR(100) as memo, need char fl
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Titre:
Re: SQL PT returns a CAST AS CHAR(100) as memo, need char fl
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Database:
MS SQL Server
Divers
Thread ID:
01178491
Message ID:
01178789
Vues:
21
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
___________________________________________
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform