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!

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

number field name

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
can you make a field name with just numbers.

example:
345

So my field name would be called 345.

How would I fetch it in an sql statement?


 
I wouldn't recommend it but I think you can do it:

create table alpha ("123" number)
 
Of course, this means you need to remember to use quotes around the column name every time you want to reference it.
Unless you have a really compelling reason to do this, it's just a bad idea. If you need to have a column with a name like "123", compromise and name it c123.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top