I have data like this:

string 1: 003Preliminary Examination Plan  
string 2: Coordination005  
string 3: Balance1000sheet
The output I expect is

string 1: 003
string 2: 005
string 3: 1000
And I

I have SQL Server table call Client_details, and there is a column called Client income. it is a text field. need to take Net Income RS 35000 as a number from this text. only 35000, example text like

We all have perfectly normalized tables, with perfectly scrubbed data, right? I wish! Sometimes we are stuck with dirty data in legacy applications. What’s worse is that we are sometimes expected to do interesting things with dirty data. In this blog, I will show you how to extract a number from a varchar column that contains letters and numbers.
First, let’s take a look at what some of that data might look like: