The MS documentation is meant to be a reference rather than a "how to use" tutorial.  The key to the problem on this post is to "find the first non-numeric...

And the problem with your question is that you did not give me the full picture.

Now you are drip-feeding clues into the thread as they come up, which is...

If the data is that consistent (some decimal value followed by character values with no spaces), no loops required, UDF scalars, or other forms of RBAR required. Just go for...

I think that one of the best answers (other than, of course, "It Depends) comes in the form of a suite of tools by Mr. Brent Ozar.  I just refer...

Wow. So simple now.

Still labouring in 2008, our next version is supposed to be 2016, with no set date for that.

I figure I'll be able to start using STRING_AGG...

Either that or look into sys.SQL_Modules, which is a system object that comes with SQL Server and can be interrogated using  T-SQL.

And now, how to put the brakes on a migration project...

Break your wrist on a bicycle ride so you only have one hand to type with and...

Quick question:   Why/for what benefit(S) should I do this?

2. After building the stored procedure, you need to run the following code to convert it into a "system" stored

procedure that...

That being said, I run SQL 2016 standard so have not had the chance to play with partitions, so someone with more experience in partitions can probably help you...

Heh... this happens during meetings, as well.  Someone goes off on a tangent or with...

Ok then... let's reword the question... how are you producing the scripts that you cite in your original post?

Jeff, if that is part of a SELECT list, what SQL dialect would that be?...

Ya know... If you were to post an actual CREATE TABLE bit of code for the pertinent columns for this...

Understood and agreed but, like was said in an article this morning, "There's nothing more permanent than a temporary fix".  It's truly unfortunate that that made the same mistake in...

"It Depends".  If this is being used in the SELECT list of a query, you can do pretty much as you please and you'll have no problems.  If it's a...