conditional update

[Najid Hanif]

I have a grid with a popup edit form and a dropdown in that form. What I would like to do is if the selected value of the drop down = 'closed', Set the SQL UpdateCommand [DateClosed] = @DateClosed

So @DateClosed = Getdate()  if drop down = 'closed'
Else  @DateClosed = NULL

Thanks

[Najid Hanif]

I have figured out a way to do this. I am using a CASE statement in my SQL UPDATE command