SQL PT returns a CAST AS CHAR(100) as memo, need char fl - Level Extreme

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

From

18/12/2006 13:17:21

Janis Booth
Webmd
Prospect, Connecticut, United States

To

18/12/2006 05:04:00

Bhavbhuti Nathwani
Venus Software Operations
Rajkot, India

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:

01178628

Views:

16

I have found this to wokr for me;

SELECT ..., SUBSTRING(Remarks,1,100) AS cRemarks ...

Janis

www.JamesBooth.com

Click here to load this message in the networking platform