CODEWITHSUNDEEP
sqlsql-serversql-server-2008
Oleksandr Fedorenko
Oleksandr Fedorenko

Reputation: 16904

Split numeric from character data

It's possible to split this data?

DATA
----------
FORD3000
MILLER1300

I want to make it like this:

ENAME | SAL
------------
FORD    3000
MILLER  1300

Upvotes: 1

Views: 1041

Answers (2)

user1700502
user1700502

Reputation: 51

SELECT SUBSTRING(@ourName, 1, CHARINDEX(' ', @ourName)) AS [First],
SUBSTRING(@ourName, CHARINDEX(' ', @ourName) + 2, LEN(@ourName)) AS[Last]

Upvotes: -1

podiluska
podiluska

Reputation: 51514

Yes. 

 select 
    substring(data, 1, PATINDEX('%[0-9]%',data)-1) as ename,
    substring(data, PATINDEX('%[0-9]%',data), len(data)) as sal
 from 
     table

Upvotes: 4

Related Questions