Running a SQL query - table include FROM and TO columns

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

On Mar 28, 9:12 am, "SoxFanInVA"
wrote:
> 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

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.