Reserved word Column Name, how do I select

S

susedom

New Member
Hello all, I'm new to Progress, coming from M$ SQL world. Liking it so far, but have stumbled upon a problem I can't seem to figure out. I know it's gotta be a no brainer, but right now, I have no brain.

I am trying to do a simple, and I do mean simple, select statement on a table. One of the field names is "number", is this a reserved word? When I try to run the following query:

SELECT CardNumber_ID, ExpDate, name, Number
FROM table1

I get the following error:

Error: Syntax error in SQL statement at or about "Number FROM table1 " (10713) (State:S1000, Native Code: FFFCCB78)

Does anybody have a solution to this remedial problem?

Thank you,

Steve
 
Thank you to any that may have replied to my query. I've found the answer among the other threads. In looking at my first post, I even put the answer in the post.

I only needed to surround the field with double quotes.

Steve
-- Learning as we grow :awink:
 
You must log in or register to reply here.
Back
Top