Invalid Column Name

[olutimi]

I have link to an Oracle 8 server.
The error ORA 01722 is displayed when ever I use a where clause in a simple select statement.
However without the where clause the column is retrieved ok. I am running the query from Query analyser of SQL Server personal edition.
Please help.

[jkoopmann]

please post the SQL and any table definitions you can and we can then go from there.

[olutimi]

Thanks. I have figured out the solution. The where clause needs to be seperate from the select clause(i.e outside the bracket.