Hi,


What are the possible ways of removing first character and last 3
characters from a string.
eg. variable values: A876479003, A675846003, A6842003.
     I am expecting the following values: 876479, 675846, 6842

Thanks,
Sri

You can use LENGTH() function to determine how long the string is then use 
SUBSTR() function to capture the range of the characters you want to keep.

"Sri" <sriseepana@gmail.com> wrote in message 
news:f4fc456a-d283-4240-ab2b-c5117ace4b50@s4g2000prh.googlegroups.com...
> Hi,
>
>
> What are the possible ways of removing first character and last 3
> characters from a string.
> eg. variable values: A876479003, A675846003, A6842003.
>     I am expecting the following values: 876479, 675846, 6842
>
> Thanks,
> Sri