Query: SELECT AccountGroup as District FROM customers WHERE Accountgroup Like concat('N4K - MI - ','%') Group by accountgroup Order By Accountgroup Result: +---------------------------------+ | District | +---------------------------------+ | N4K - MI - TawasSchool | +---------------------------------+ Query: SELECT AccountGroup as District FROM customers WHERE Accountgroup Like concat('N4K - MI - TawasSchool','%') Group by accountgroup Order By Accountgroup Result: Empty Set.