Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Blank memo in sql-select
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00341223
Message ID:
00341235
Views:
29
I don't know of one. I have always kept a dummy table with a blank memo field and just add this to my SELECT statement.

SELECT table1.fields,,, IIF(EMPTY(table1.notes), dummy.blank, table1.notes) AS notes FROM table1, dummy blah, blah, blah

you won't need a WHERE condition for the dummy.
Larry Collins
TheProgrammerGuy.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform