What DB are you using? Gonzalo. > 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]