Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 SQL Query help

Author  Topic 

saidev
Posting Yak Master

101 Posts

Posted - 2006-05-31 : 19:50:16
Hi Guys,

Need help with this query. It's a simple query.

"SELECT * FROM XYZ where InActive = 0 "

it is giving me error that " Incorrect Syntax near where"

I tried with (inactive = 0) but still the same error.
it works fine in the Query Analyzer.
appreciate your help guys

Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-05-31 : 19:52:08
If it works fine in Query Analyzer, then the problem is with your application code. You have not posted your application code, so it's hard to help you with this.

Tara Kizer
aka tduggan
Go to Top of Page
   

- Advertisement -