[snip] $Query=" SELECT FieldName1, FieldName2 FROM TableName WHERE FieldName1 LIKE '$CriterionRecord' "; [/SNIP]
The LIKE criteria needs to be surrounded by wildcards... WHERE FieldName1 LIKE '%$CriterionRecord%' HTH! Jay -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
