Hi Andrew Which part is failing? The inner SELECT, or the UPDATE? Do you get an error message or unexpected results?
What do you get if you dump the select statement using either syntax for null? What DB platform, etc? On 7/31/06, Andrew Scott <[EMAIL PROTECTED]> wrote: > > Anyone explain what I am doing wrong, I did this once before, but I don't > see why this shouldn't work? > > UPDATE BookingOptions > SET IsConfirmed = 1 > WHERE (SELECT BO_BookingDate FROM Bookings WHERE BO_BookingDate != NULL) > > I even tried is not null:-) > > > Senior Coldfusion Developer > Aegeon Pty. Ltd. > www.aegeon.com.au > Phone: +613 8676 4223 > Mobile: 0404 998 273 > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2533 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
