I have the query $cur= odbc_exec( $cnx, "SELECT Location, 'Dept ID', 'Equip Type' FROM Equipment01 WHERE Location = '415C'"); which returns the proper results but when I add AND 'Equip Type' = 'C' to the end of it I get no results. Is my syntax correct? Thanks, Aaron $cur= odbc_exec( $cnx, "SELECT Location, 'Dept ID', 'Equip Type' FROM Equipment01 WHERE Location = '415C' AND 'Equip Type' = 'C'"); -- PHP Windows 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]