Creating a Data Source from an SQL Statement
Enter a complete SQL statement. For example:
SELECT * FROM CONTACTS
When accessing larger databases (more than 50,000 records), it's useful to structure the SQL statement as a cursor. You do this by preceding the SELECT statement with the keyword CURSOR. For example:
CURSOR SELECT * FROM CONTACTS
If you specify a time, be sure to use the following format (those are zeroes at the end): yyyy-mm-dd hh:mm:ss.000
If you specify an SQL statement that includes a "where" clause (such as select * where EMAIL_ like '%Doc%'), the evaluation is case-sensitive. In other words, the query will not return records containing "doc" or "DOC" as in very early versions of the software.