Take the SQL sentence SELECT field1,field2 FROM my_table WHERE LEFT(field3) = '$var' and execute it in your database client (outside Perl). SQL should be tested in the database. Put a number instead of $var. BTW, I think you should select field3 before you can use it in the function LEFT(field3).