Select the first N digits of string ?
string 2: 050 – Site Management
string 3: White Card
The output I expect is
string 1: 084
string 2: 050
string 3: Null
And I want to implement it in MS SQL.
I have data like this:string 1: 084 – Go / No Go Training – Expanda
string 2: 050 – Site Management
string 3: White CardThe output I expect isstring 1: 084
string 2: 050
string 3: Null
And I want to implement it in MS SQL. Read More