i am trying to match string A to these scenarios (sql table values)

string A = "G283H88620TS"

matching sql table values
MX0G2H883H7426288620TS (contains the string but has characters before, in the middle, and at the end)
UIERG283H88620TSERU (contains the string but has characters before and at the end)
G283H88620TSKDJF (contains the string but has characters at the end
KEKEG283H88620TS (contains the string but has characters at the begining

unfortunately there is no pattern as to where these interrupting characters reside

(this only works for the last 3 scenarios but not the first)

"SELECT * FROM aInventoryInfo WHERE SerialNumber LIKE '%" & $serial & "%'"