General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Extra memo field in an SQL select
Hallo everybody
If I want an extra character field in an SQL select I can write:
SELECT * ,SPACE(10) AS cFIELD1 FROM SOURCETABLE INTO TABLE RESULT
If I want an extra numeric field in an SQL select I can write:
SELECT * ,000000 AS nFIELD1 FROM SOURCETABLE INTO TABLE RESULT
But! How do I write if I want an extra memo field in an SQL select???
I hope someone can help me.
Thanks in advance
/Kjell
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only