On 5/1/08, Irin later <email@example.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
HINT: consider the use of the null string "".