Steven,

Assuming you have an ODBC driver and connection to the database:

SQLExec( gnSQLHandle, "select * from TheTable where DrawingNumber between 10000 and 399999" )

>I need a select statement that will select records from an as400 database with drawing numbers between 10000 and 399999.