jMarcel jMarcel - 1 year ago 69
SQL Question

T-SQL Create Id column from a Name column

I'm trying to separate the name column and create an id column as below:


John F1234567
Mary F7654321

What I've done until now is:

select RIGHT(name,8) as id, name FROM myTable


id name
F1234567 John F1234567
F7654321 Mary F7654321

But the result I need is:

id name
F1234567 John
F7654321 Mary

I've used some string functions, but no success.

Can anyone help me, please?

Thanks in advance.

Answer Source

You can try using replace function

select RIGHT(name,8) as id, replace(name, right(name,8), '') as name FROM myTable
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download