Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Memo fields in SQL-SELECT statements
Message
From
22/09/1997 13:52:12
Elyse Pomerantz
Dynamic Data Concepts, Inc.
Brooklyn, New York, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Memo fields in SQL-SELECT statements
Miscellaneous
Thread ID:
00051069
Message ID:
00051069
Views:
65
To avoid NULL values in my cursors, I use something like SELECT NVL(MyField,space(len(MyField))). From what I understand, the first record in a SELECT statement determines the field's width. Since memo fields are of varying length, how do I select a memo field without getting a possible NULL value? i.e. SELECT NVL(MyMemoField,space(???))

Thanks
Elyse
Elyse Pomerantz
Next
Reply
Map
View

Click here to load this message in the networking platform