Lorenzo, That was a good suggestion (had forgotten about the between function) but unfortunately it still complains with the following error:
Warning: SQL error: [Microsoft][ODBC Microsoft Access 97 Driver] Data type mismatch in criteria expression., SQL state 22005 in SQLExecDirect in test.php on line 6 What caused this error was this: WHERE PARTNUMBER.PARTNUMBER BETWEEN 370100000 AND 500000000"); So, any other suggestions on how I can circumvent this problem? Brgds, Christian -----Original Message----- From: Gonzalez, Lorenzo [mailto:[EMAIL PROTECTED]] Sent: 15. november 2001 14:57 To: Christian Sandfeld; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Converting "text" fields to "integer" in queries with ODBC connection to an MS Access file Some of the databases I work with would support this as 'between' on two text fields that are sortable alphabetically - I'd give that a try. -Lorenzo -----Original Message----- From: Christian Sandfeld Sent: Thu 11/15/2001 7:55 AM To: '[EMAIL PROTECTED]' Cc: Subject: [PHP-DB] Converting "text" fields to "integer" in queries with ODBC connection to an MS Access file Hi list, I wonder if anyone can help me out here. I'm pulling some data from an MS Access file using the ODBC driver provided with Windows NT 4.0 server (Option pack, and SP6a applied), and want to limit the result set with a where clause like this one: ... WHERE (PARTNUMBER > 370100000) AND (PARTNUMBER < 500000000) Now - the problem here is that the "PARTNUMBER" field is defined as a "text" field in the access file (even though it holds only numbers), and since I'm not the one maintaining the access base, I can't change that. So I tried converting the field to an INTEGER field using the CONVERT() function in my query. But this function is not supported by the ODBC driver. Does anyone know how I can convert the value of as "text" field to an "integer" type field so I can do >/< clauses in my query? Any help will be greatly appreciated. Brgds, Christian -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]