|
On 5/1/08, Irin later <irinfigvam@yahoo.com> wrote:
> I have newid for example
> ADAM19480204M (name+year+month+day+gender)
> I need to rebuild it in order it looks like:
> ADAM194802M (name+year+month+gender)
>
> (Name can vary up to 5 letters)
> In other words I need to take out DAY part.
You have at least one function at your disposal: SUBSTR().
In particular, if only name varies, you might be able to use:
SUBSTR (left of =) Function
Online example:
a='KIDNAP';
substr(a,1,3)='CAT';
put a;
CATNAP
HINT: consider the use of the null string "".
| 
