-
Contributing Member
Query with SQL Leading Zero
Is it that SQL will not save any leading zeros of a field data type int or numeric? If it is so then how can one make the leading zeros stored if they really want it?
-
Expert Member
Re: Query with SQL Leading Zero
store them as character data...
-
Contributing Member
Re: Query with SQL Leading Zero
Thank you. I tried and it worked. Good tip that provided me the insight about the data types in SQL.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules