Thank you Mr Burrows! 🙂

CHARINDEX with a CAST worked like a charm.

Hello Frank

Thanks for the reply.

I just realised that the variable can also be = 1,2,5. So upper and lower bound would not work.

I thought of building up a SQL string,...