my $l = length($var); my $query = "SELECT field1,field2 FROM my_table WHERE LEFT(field3,$l) = '$var'"; #### --- print map { my ($m)=1<