Thank this author by sharing:
By Boyd Tyrrell,
Simple function to retrieve numbers from within a passed string value. Will find integers, negatives, and decimal values and ignores numbers with more than one decimal. Returns a table with the start position in the string and the number value from the string.
Function to take a number as a string and return it with commas separating thousands, millions, etc....
Convert char string to number
Find the occurence of number in string and extract
'string' = 'string___' ???
Function to extract x number of words from the start of a string
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.