I am glad we are cool. 🙂

The first code I submitted worked for me to clean up some data for my company. In my case the goal was not to...

Brandy

I do not question Jeff merits and impressive contributions, nor I question yours. honestly, no sarcasm here. But I did feel his response as being as rude to me in...

What you are asking for is called regex. Google it, there are plenty of very good sites about it. I do not think I can improve its flexibility, so no...

Converting into money and from there into int, float or some other numeric data type could be a valid solution for many cases and would perform better than a UDF....

You can convert to data type money everything identified as isnumeric().

Try this:

[font="Courier New"]SELECT [Ascii Code] = STR(Number),

...