General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Good Day all!
My question is this...I have a field in my table called OrderId it is 7 characters long. If an id is entered that is three characters (ex. 123) I would like to have it replaced with leading zeros to the max of C(7) (ex. 0000123). Is this possible to do in the table designer..input mask or format fields? Any other suggestions?
Thanks for your time!
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only