-
Format Data Type using DDL
Hi,
How do I create a table with currency field, format is "Standard" and Decimal place is 0 by using SQL CREATE TABLE command?? for example, once I enter 245500, the field will be auto change to 245,000, instead of 245500.
Below is my SQL command,
CREATE TABLE TestTable (UserName VARCHAR(20), Job VARCHAR(20), Salary Currency, Status VARCHAR(20))
I'm using access database.
pls advice.
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
|
|