Quick Question

Results 1 to 2 of 2

Thread: Quick Question

  1. #1
    Join Date
    Dec 1969

    Default Quick Question

    I have a table in SQL called 5day. When I use a select * from 5day I get an error, but when I rename to fiveday it works. Can I not use a number in the table name??

  2. #2
    Join Date
    Dec 1969

    Default RE: Quick Question

    I know that you can&#039;t have variables that start with a number (in VB and ASP). It sounds like SQL Server is the same.<BR><BR>But, in SQL Server, you can get around that. Just do:<BR>SELECT * FROM [5day]<BR><BR>But, I&#039;d suggest a different table name.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts