>> I have a TBL of users and I have created a search screen where you can type in >> first or last name and it will retrieve the appropriate records. Here is the statement:
>> "Select * from STUDENTS WHERE FName LIKE '%" .$_REQUEST['searchit']. "%' >> OR LName LIKE '%" . $_REQUEST['searchit']. "%' OR idStudent LIKE '%" >> .$_REQUEST['searchit']. "%'" I'm assuming you're using PHP with MySQL because of the reference to $_REQUEST and using . To concatenate. It could be a case, whitespace or data type issue. Try using: "SELECT * FROM students WHERE lower( trim( FName ) ) LIKE '%" . strtolower( trim( $_REQUEST['searchit'] ) ) . "%' OR lower( trim( LName ) ) LIKE '%" . strtolower( trim( $_REQUEST['searchit'] ) ) . "%' OR lower( trim( idStudent ) ) LIKE '%". strtolower( trim( $_REQUEST['searchit'] ) ) . "%'" If your idStudent field is a numeric data type then you need to do an equality comparision rather than a like... "SELECT * FROM students WHERE lower( trim( FName ) ) LIKE '%" . strtolower( trim( $_REQUEST['searchit'] ) ) . "%' OR lower( trim( LName ) ) LIKE '%" . strtolower( trim( $_REQUEST['searchit'] ) ) . "%' OR idStudent = ". $_REQUEST['searchit'] If this doesn't work please post the table structure (describe tablename) and your PHP script. Cheers Dean -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]