How do I remove a digital 0 in front of the access database-CodePudding

Home > database > How do I remove a digital 0 in front of the access database

How do I remove a digital 0 in front of the access database

Time：10-05

Access database in a field for "0003", "0016" how to write SQL query results of 3 dec?

CodePudding user response:

The format function format good

Select the format (field name, "#")
From the name of the table