I was hoping someone could please help me.... I am using TSQL and was aiming to be able to be able to complete my query by completing the set of partial strings. I have inserted a sample of what I needed to do (see image). Initially, I only have the column names: "Partial Strings" and I have a separate Table named "Lookup List". Limitations are:
1. No other objects to be used as their unique identifier.
2. "Partial Strings" have no specific number of characters, and can appear in as little as 2 first characters