Le lundi 16 f�vrier 2004, Zabach, Elke a �crit...
bonjour,
> now it depends, if the seq_Number has to have leading '0' within the new key
> or not
> substr(oldkey, 1, 4) ||
> lfill (ltrim(chr(fixed (num(substr(oldkey, 5)) + 1, n, 0))) , '0', 7)
> should result in a 11-char new-key with leading '0' in seqNumber
> (assuming n is not > 7)
fine, thanks, that's all I wanted, and a little bit more (having leading 0 is
rather pretty).
> And this you want to do in a dbproc or (with version 7.5.1) in a user defined
> function?
yes. But why 7.5.1 ? Isn't 7.5.0.8 aware of user functions ?
--
jm
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
