Hello, I'm looking for help with a simple query that will compare two fields on the same row to see if the first 5 characters match. If they match the row will be displayed. Every duplicate query i see is comparing columns against the whole shee and not a single row. ANy suggestions and help are appreciated.

We can call the columns Test 1 and Test 2.