Thanks, this is what I was looking for 🙂 I do realize that every row/column will affected but I will be building other CASE statement for when Cpay_Stop IS NOT...

Thanks David, I agree with you that the WHERE clause will right away update correctly the row. I am trying to use the CASE statement with out he Where Clause,...

I try based on your script updating a single entry that has NULL using CASE to get a better understanding but I ran into another error. Here is the code...

Thanks Celko, I will work with your suggestions and let you know

Thanks Duncan, I did try your code but did not manage the the nulls correctly, I will tinker with it further.;-)

Thanks, I am trying to determinate the right syntax to execute the code but with out a good example I am trashing around.;-)

Thanks but....

Under normal conditions that will be the case but there are different programs acting on the same table with one having to be a bit and the other string.

You were right there was a couple of typos(the usal gotcho!).

I there a way of doing the update only to the new row and every row?

Lynn - Here is the code, I did underscore the two items involved

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[tbl_clPDB](

[clPDB_ID] [int] IDENTITY(1,1) NOT NULL,

[clPDB_DOE] [datetime] NOT NULL CONSTRAINT [DF_tbl_clPDB_clPDB_DOE]...