Preceding a number by '0' How to use SQL statement

athena815

Add 0 upstairs
But how do you save it to the database in this case?

3121589a

There is no need to add 0 to save to the database. Don't forget that he uses DELPHI to do it. I think he means to add a 0 to the data extracted from the database when designing the interface. Then the writing statement is just DELPHI. The problem is, no SQL

adide01

[Quote=quote the reply oflonelywenyion the 9th floor:]
RIGHT(100000000+field name, 8)
[/Quote] Worshiping 9L has solved my problem!