[Cialug] SQL question

[Chris Hilton]

http://www.w3schools.com/sql/sql_update.asp

I've used access, and it followed the standard, at least the basic parts of 
it.  So something like:
update table_name
set Close="yourvalue"
where SalesStatus="Spec"




On Wednesday 15 March 2006 13:34, David Stout wrote:
> I am using SQL server and I have a column named
> SalesStatus and one Named Close in my in the SalesStatus field I have
> values like BTO, Model, ssip, and Spec  In the field named Close this is
> just a closing date. What I need to do is this:
>
>   If SalesStatus='Spec' Then put the value of the closed field in here.
>   else '<blank>'
>
>   How do I write such a query?
>
>   Thank you,
>   David Stout
>   Ragbari65 at yahoo.com
>
>
> ---------------------------------
> Brings words and photos together (easily) with
>  PhotoMail  - it's free and works with Yahoo! Mail.

-- 
"The only winning move is not to play."