Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 select a field from a table with fieldname

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-05-29 : 09:26:48
Aneesh writes "I have to select a field named "from" from a table. How can i query this. Also how can I manage queries when keywords occure as a field name"

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2002-05-29 : 09:41:03

select [from] from tablename

 


<O>
Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-05-29 : 12:16:51
quote:
Also how can I manage queries when keywords occure as a field name

Change your object names. DO IT. NOW. Whoever created these objects and named them that way, if it wasn't you, go and smack them in the head repeatedly. If YOU named them, smack yourself in the head repeatedly.

YOU WILL CONTINUE TO HAVE PROBLEMS like these as long as your objects are named after keywords. Bite the bullet, change them now, and be done with it.

Go to Top of Page
   

- Advertisement -