Hi herado,

Thank you very much...

but one more question....
the XXX is a different value there just for example....

For example 001234, 005489, 004566, 000234 etc... so I just said it as 00XXX is for easy understand ...


For the MySQL's SQL... How to make it know I just change all value start from 00, and 000 to EK00, EK000?

Your value in the SQL example of 00XXX to EK00XXX is a absolute value, how do it know need to change all value starting from 00?

Thank you very much again of your kindly help and time.