Split or subtract value

[srinivasa1]

Hi

pl guide me, how i can subtract or split  value into two filed  from below list

01-Mohan-ABC-IT

02-Raj-test-A/c

03-Abh-Rohab-A/c

i would like to substrata into two filed as below

Filed

01

02

03

Filed 2

Mohan-ABC-IT  

Raj-test-A/c

Abh-Rohab-A/c

[luis_pimentel]

You could play withLEFT(), RIGHT() and LEN() funcions, like:

LEFT(yourfield,2) AS Field1,

RIGHT(youfield,LEN(yourfield)-2) AS Field2

[luis_pimentel]

Take a look also to the SUBFIELD() function.

[#4]

or you use subfield(yourfield,'-',1) as Field1

and right(yourfield,len(yourfield)-3) as Field2

[ashwanin]

Hi Srinivas,

Please go through the qv.

Here two functions used to get your desried output.