[Cialug] SQL question

[David Stout]

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://cialug.org/pipermail/cialug/attachments/20060315/efc74cd4/attachment.htm