Excellent Cadavre! I had to tweak around on my allowed and non-allowed characters. But, It gave me the result that I expected. Thanks much.

Thank you for your reply Cadavre. But, I am looking for something different.

I want only the characters to th left of the first occurance of any list of special...

Thanks Dwain. I look forward for GSquared's help and dig more into PATINDEX. I will update here if I find any solution.

Thank you for your response Dwain.

Can I include the characters . - also in allowed character list? If yes, how would I do that?

I tried this, but didn't work.

SET...