I want to search by extracting only a part of the scanned text string

[yj_Lee]

I have a column in my table with a unique code value of 8 digits.
However, when I scan the QR code, it scans with a longer string.
The string I’m looking for is part of the scanned string (8 digits).
Is there a way to extract the scanned value and find one that matches the value in my column?
Thank you.