Running a SQL query - table include FROM and TO columns

[SoxFanInVA]

I am trying to export some calendar data from a sql table. This table has 2
column names "from" and "to" for the time range of the appointment. When I
run the sql query:
select date, from, to, act_code, mat_code, clt_code, notes, descrips,
atty_list from appoint where atty_list like '%xxx%'
I get an error. I'm assuming it's because "from" and "to" are sql commands
and doesn't recognize them as column headers? How do I extract the data
from those columns and trick the query into thinking those are not sql
commands?

Thanks,
Tom

[Jesse]

Post by SoxFanInVA
I am trying to export some calendar data from a sql table. This table has 2
column names "from" and "to" for the time range of the appointment. When I
select date, from, to, act_code, mat_code, clt_code, notes, descrips,
atty_list from appoint where atty_list like '%xxx%'
I get an error. I'm assuming it's because "from" and "to" are sql commands
and doesn't recognize them as column headers? How do I extract the data
from those columns and trick the query into thinking those are not sql
commands?
Thanks,
Tom

wrap the reserved words in square brackets:

select [to], [from] from mytable

also it's bad practice to use reserved words in your object names, for
exactly this reason.

[SoxFanInVA]

Thanks Jesse, that is a helpful tip that I didn't see in my SQL cheat sheet.

This isn't a database I created nor am I in a position to edit it so we are
stuck with what we have. We rarely use any custom sql queries and I'm the
only one doing so. So it's not a big deal at the moment.

Thanks,
T

Post by Jesse

Post by SoxFanInVA
I am trying to export some calendar data from a sql table. This table has 2
column names "from" and "to" for the time range of the appointment. When I
select date, from, to, act_code, mat_code, clt_code, notes, descrips,
atty_list from appoint where atty_list like '%xxx%'
I get an error. I'm assuming it's because "from" and "to" are sql commands
and doesn't recognize them as column headers? How do I extract the data
from those columns and trick the query into thinking those are not sql
commands?
Thanks,
Tom

select [to], [from] from mytable
also it's bad practice to use reserved words in your object names, for
exactly this reason.