Remove Leading characters

Wideawake

New member
Local time
Today, 23:48
Joined
Feb 28, 2008
Messages
1
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 :)
 
Try MID(YourField,5)
 
Last edited:
Hey Wideawake ... are you asleep? Did this solve your issue?
 

Users who are viewing this thread

Back
Top Bottom