Hey Tracy - thanks SO Much! That looks simple enough to use - but, doesn't look like something someone would be easily able to find in the online help!
Thanks again, -K- -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Tracy Pearson Sent: Wednesday, April 04, 2012 5:41 PM Kurt Wendt wrote on 2012-04-04: > I hope this doesn't sound like a stupid question. And, I did look in the > online help for the answer - but, a quick search under SQL SELECT did > not reveal the answer. > So - here's the deal. I know I can define an empty column in an SQL > SELECT based upon Spaces using something like: > SPACE(6) AS DummyField > But, I don't know how to do it for a Memo field. I saw that I do have a > Memo field coming from this one DBF in my current SQL Select - but, now > I removed that Memo field due to problems (as I stated in a Thread a > several weeks ago here) . So - now I want to generate an Empty Memo > field - that I will then fill with data After the main Select has been > accomplished. I even tried: > Memo AS DummyField > However, obviously that did NOT work... > TIA, > -K- > Kurt, CAST("" AS MEMO) AS DummyFiled Tracy Pearson PowerChurch Software _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/289ea162f5642645b5cf64d624c66a140b7ce...@us-ny-mail-002.waitex.net ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
