Thank you<BR><BR><B><I>"Dave J. Hala Jr." <dave@58ghz.net></I></B> wrote: <BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">UPDATE table SET table.SaleStatus = table.Closed WHERE table.SaleStatus<BR>='Spec'<BR><BR>This looks at all records where SaleStatus = 'Spec', then in those<BR>records it sets the value of the SaleStatus field to the value of the<BR>Closed field. You'll want to make sure that the SaleStatus and Closed<BR>fields are the same data type.<BR><BR>:) Dave<BR><BR><BR><BR><BR>On Wed, 2006-03-15 at 13:34, David Stout wrote:<BR>> 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<BR>> values like<BR>> BTO, Model, ssip, and Spec In the field named Close this is just a<BR>> closing date.<BR>> What I need to do is this:<BR>> <BR>> If SalesStatus='Spec' Then put the value of the closed field in here. <BR>> else
'<BLANK>'<BR>> <BR>> How do I write such a query?<BR>> <BR>> Thank you,<BR>> David Stout<BR>> Ragbari65@yahoo.com<BR>> <BR>> <BR>> ______________________________________________________________________<BR>> Brings words and photos together (easily) with<BR>> PhotoMail - it's free and works with Yahoo! Mail.<BR>> <BR>> ______________________________________________________________________<BR>> _______________________________________________<BR>> Cialug mailing list<BR>> Cialug@cialug.org<BR>> http://cialug.org/mailman/listinfo/cialug<BR>-- <BR><BR>Open Source Information Systems, Inc. (OSIS)<BR>Dave J. Hala Jr., President <DAVE@OSIS.US><BR>641.485.1606<BR><BR>_______________________________________________<BR>Cialug mailing list<BR>Cialug@cialug.org<BR>http://cialug.org/mailman/listinfo/cialug<BR></BLOCKQUOTE><BR><BR><BR>David Stout<br>Systems Programmer<br>Regency Homes<p>
<hr size=1> Yahoo! Mail<br>
<a href="http://pa.yahoo.com/*http://us.rd.yahoo.com/evt=38867/*http://photomail.mail.yahoo.com">Use Photomail</a> to share photos without annoying attachments.