John,
I looked at the syntax for the SQL where clause in my SQL 6.5 books online.
BETWEEN IN SQL Server is a keyword not a fuction. You syntax should be
x BETWEEN 1 AND 100
When using SQLExec you need to make sure to use the syntax of the database server you are querying.
Thanks,
Rod
Rod Paddock
Editor in Chief CoDe Magazine
President Dash Point Software, Inc.
VP Red Matrix Technologies,Inc.