$client_name = $query->param('client_name'); chomp $client_name; #### $sql = "SELECT * FROM tblClient(NOLOCK)"; my $sth = $dbh->prepare( $sql ); $sth->execute; while ( my $result = $sth->fetchrow_hashref ) { if ($result->{Client_Name} =~ /$client_name/i){ print "$result->{Client_Name}"; print "$result->{Email}"; print "$result->{Address}"; print "$result->{Phone}"; print "$result->{Fax}"; # Count is used to store the number of matches $count++; }