how to eliminate first 4 char.

[rohit214]

Hi  all,

I want to eliminate 1st 4 char fropm my customer name field

eg.Mr. Xyz I want only Xyz

thanks&regards

rohit

[CELAMBARASAN]

Hi,

     Have u tried with this?

     Load

          Right(CustomerName,Len(CustomerName)-4) as CustomerName

     From..

Hope it helps

Celambarasan

[jagan]

Hi,

The Script below works fine as Celambarasan suggested

Load

          Right(CustomerName, Len(CustomerName) - 4) as CustomerName

          '

          '

From DataSource;

Regards,

Jagan.

[SunilChauhan]

Use this

mid(Customername,5,len(Customername)-1)

hope this helps