odbc connection

[djsparkle]

I have encountered a problem while trying to setup a query using odbc connection. I'm trying to connect to a table where one of the columns is named "GROUP" and that column needs to be used in my WHERE clause. The problem is that odbc is recognizing the GROUP as function rather than a column name.. Any ideas on how I can get around this?

Thanks

[tasistro]

Rename the column GROUP to something else. Personally I'd use GRUPO

Saludos
Gerardo

[djsparkle]

well, that's the problem. I'm unable to rename the group column bacause it's in a another database called advantage. I can only access the database via odbc and can't edit the tables.

[tasistro]

try

SELECT %WHATEVER FIELDS% FROM group as grupo WHERE %WHATEVERWHERECRITERIAHERE%

Saludos
Gerardo

[djsparkle]

The group is in my WHERE clause.. ex:
SELECT * FROM sometable WHERE GROUP='somevalue';