What is error in query

[Pradeep]

update wk_share set deleted='Y',where fund_id="" and share_id="";
please tell me error in above query
[ November 23, 2006: Message edited by: Bear Bibeault ]

[Jeanne Boyarsky]

Pradeep,
For the future, note that we have a JDBC forum for SQL questions.

What error do you get? Do you want to check for empty strings or nulls?

[A knibbs]

this is more of an sql problem, but I think the problem is the comma before the word where. (You should use an sql forum for this, not to mention including details about which db etc etc)

[Merrill Higginson]

Also, you've used single quotes for one comparison and double quotes for two other comparisons. Some databases only accept single quotes to denote literals.

If you're trying to check for null, you should use the expression:

fund_id is null
[ November 23, 2006: Message edited by: Merrill Higginson ]

[Pradeep]

thanks it helped me

[Pradeep]

thanks it helped me