Hi,
I am trying to select specific records in a Pervasive 2000 table using a SQL
command.
The command is :

SELECT name AS customer, desc AS description FROM tblroll

However, it gives a syntax error. It seems that "desc" is a reserved word.
Unfortunately I do not have the luxury of changing the field name as I am
simply connecting to a database from another application to manipulate the
results for my own application.
Does anyone have any ideas on how I may choose this specific field from the
table?

Thanks in advance.

H.M.L.W.

You'll need to enclose the field name in double quotes:
SELECT name AS customer, "desc" AS description FROM tblroll
That will allow you to access the field.