I have let DreamWeaver with PHAkt 3.2.0 do all the coding, so that that is why all the wild cards are there. You can see from the code below I just wanted to get on with the job of accessing the database. [code]$maxRows_Recordset1 = 500; $pageNum_Recordset1 = 0; if (isset($_GET['pageNum_Recordset1'])) { $pageNum_Recordset1 = $_GET['pageNum_Recordset1']; } $startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1; $colname__Recordset1 = '-1'; if (isset($_POST['PartNo'])) { $colname__Recordset1 = $_POST['PartNo']; } $query_Recordset1 = sprintf("SELECT * FROM PartsTable WHERE PartNo LIKE '%%%s%%' ORDER BY PartNo ASC", $colname__Recordset1); $Recordset1 = $connPodium->SelectLimit($query_Recordset1, $maxRows_Recordset1, $startRow_Recordset1) or die($connPodium->ErrorMsg()); if (isset($_GET['totalRows_Recordset1'])) { $totalRows_Recordset1 = $_GET['totalRows_Recordset1']; } else { $all_Recordset1 = $connPodium->SelectLimit($query_Recordset1) or die($connPodium->ErrorMsg()); $totalRows_Recordset1 = $all_Recordset1->RecordCount(); } $totalPages_Recordset1 = (int)(($totalRows_Recordset1-1)/$maxRows_Recordset1);[/code] SELECT * FROM table where field = '$itemnum' would be great if the suppliers would not mess with primary keys. There are 4 suppliers with 4 different database tables of parts. I have managed to get them in to one table (36,000 entries) the problem is 2 of the suppliers have added there own prefix and suffix in the database to the part numbers. Most of these parts are for radio control cars. If you read the instructions for example a nitro engine may be part number 8029 in the instruction manual and that is what you would want to order. The supplier then adds something like a H so they know which manufacturer it is from. The instruction manual may not have a part number for the engines piston and other parts so the supplier will create suffix of -29 for the piston or -1 for the engine. So in our database we have H8029-29 for the piston when all the client has as part number of 8029. Therefore I need something a little more to find the all the possible parts. Thank you for your help and I will have a go at reviewing the wild cards.