--- trunk/index_DBI_cache.pm	2004/01/11 21:06:42	200
+++ trunk/index_DBI_cache.pm	2004/01/17 14:00:26	201
@@ -161,7 +161,7 @@
 		} else {
 			# if no match is found when searching from beginning
 			# of word in index, try substring match anywhere
-			$sql2 = "select ord from $field where upper(item) like '%'||upper(?)||'%'";
+			$sql2 = "select ord from $field where upper(item) like '% '||upper(?)||'%'";
 			$sth = $self->{dbh}->prepare($sql2) || die "sql2: $sql2; ".$self->{dbh}->errstr();
 			$sth->execute($where) || die "sql2: $sql2; ".$self->{dbh}->errstr();
 			if (my $row = $sth->fetchrow_hashref) {