>Dear friend
>
> I have one field and want to pass it for two fields
Well you add the two fields (name and number) to your table and then you execute my 2 statements and the you delete your original field.
Sergei's to use substr(YourOriginalField,7) is slightly more general than mine though.
But you will end up doing everything in the same table, which was what you wanted right?
If things have the tendency to go your way, do not worry. It won't last. Jules Renard.