Where IN SUBSTR IF Statement

I have numbers in a barcode scanner that are adding digits to the front and end of an entry

I'm trying to query to give me the first 8 -> 24 digits of the entry

where xx.tracking_id in ('&First_Tracking','&Second_Tracking','&Third_Tracking','&Fourth_Tracking','&Fifth_Tracking')

So if I scan the barcode XXXXXXX1234567890111222YYYYY only query on 1234567890111222 for the scan.

Also I only this to happen for when my name is Tiki