Extract All Numbers from a String in SQL

(Hannes du Preez) In SQL you can use PATINDEX (which makes use of Regular Expressions) to extract all the numbers from within a string as shown:

Read More – Register for a Membership/membership]
Read More (Community content)