<DIV>I am using SQL server and I have a column named <BR>SalesStatus and one Named Close in my in the SalesStatus field I have values like</DIV> <DIV>BTO, Model, ssip, and Spec In the field named Close this is just a closing date.</DIV> <DIV>What I need to do is this:</DIV> <DIV> </DIV> <DIV>If SalesStatus='Spec' Then put the value of the closed field in here. </DIV> <DIV>else '<blank>'</DIV> <DIV> </DIV> <DIV>How do I write such a query?</DIV> <DIV> </DIV> <DIV>Thank you,</DIV> <DIV>David Stout</DIV> <DIV><A href="mailto:Ragbari65@yahoo.com">Ragbari65@yahoo.com</A></DIV><p>
<hr size=1>Brings words and photos together (easily) with<br>
<a href="http://us.rd.yahoo.com/mail_us/taglines/PMall/*http://photomail.mail.yahoo.com">PhotoMail </a> - it's free and works with Yahoo! Mail.