Remove Leading characters (1 Viewer)

[Wideawake]

Hi Guys

Sorry for this being a short post, but I am pushed for time. The problem I have is I have data in a field as follows
“CCSE123456” and I need to be able to run a procedure to remove the leading 4 characters, i.e. “CCSE”. The problem is I can remember how to do this. LTRIM is no good as these are not blanks or leading spaces and when I tried to use StrDel I was told it wouldn’t compile. I know it can be done, but would appreciated a little nudge in the right direction.

Thanks in advance

Wideawake

 

[pdx_man]

Try MID(YourField,5)

 

[pdx_man]

Hey Wideawake ... are you asleep? Did this solve your issue?