Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

create null field with number format

Status
Not open for further replies.
yahooLuke

yahooLuke

Programmer
Sep 29, 2006
1
US
Currently, fields SumOfWidth and SumOf Length are being created as Binary and I am trying to make them number format. How can I format my new fields to number format?

Thanks,

SELECT Habitats.FiscalYear, Null AS SumOfWidth, Null AS SumOfLength
 
Sort by date Sort by votes
What exactly are you trying to accomplish? Are you making a table or something with the SQL?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

combo
  • Locked
  • Question
SQL data types in CREATE/ALTER TABLE queries 1
Replies
2
Views
2K
combo
combo
Swi
  • Locked
  • Question
Select X of each variation of a field 1
Replies
8
Views
616
rashmibala
R
serino
  • Locked
  • Question
Find a number between two sets of numbers. 1
Replies
2
Views
1K
serino
serino
serino
  • Locked
  • Question
Help with a Query. 1
Replies
13
Views
981
strongm
strongm
datajockey123
  • Locked
  • Question
Note / Information box with date and time stamp for each entery
Replies
2
Views
862
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top