> meant to store data, not to format it while storing.
> Actually I find this to be a nice feature...if necessary.
> For instance you are using Auto_Increment INT field and you
> are using it as your order number. Maybe you want all of
> your order numbers to be a specific length.
I actually found it usefull with barcodes which in the US are only 12 digits
but in Europe are exactly the same format but 13 digits long. Adding a zero
to the beginning of a US code makes it a European compatible code.
--
Jay
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]