[Michael Hunter]

I like dan’s code. If distinct you can also create a strings a libraries and switch on charindex(input)