How to split value to two values

[#1]

Hi,

I have PhoneNoMobile and PhoneNoWork columns in sql table with values 447341891543,447897674285 as combined in PhoneNoMobile  and column PhoneNoWork contains some NULL values and values with Data .

I have to split the above value as PhoneNoMobile=7341891543 and PhoneNoWork=447897674285

Is it possible to get this and I have to split this values only when PhoneNoWork contains NULL values i,e if PhoneNoWork=NULL then it should replace with 44789674285. Please help

Thanks.

[#2]

Thanks and it's working.

[#3]

Thanks and it's working.