how to use group in a SQL statement

Hello!

I have a field called group. I'd like to write a SQL statement using the group field in the where clause, however the SQL Worksheet recognizes it as an reserved word only.

select * from example
where group = "mygroup";

How to get this working? I'm using Oracle 9.2 and I did try to put " and ' around the field name.

thanks
Tom Received on Wed Oct 08 2003 - 16:18:29 CDT