Case Statement syntax help 1

[allyne]

Hi Everyone,

I need to create a case statement like -

CASE
WHEN tblIrdbMonths.[90Days] IS NULL
THEN Update tblIrdbMonths SET tblIrdbMonths.[90Days] = [60Days]
ELSE tblIrdbMonths.[90Days]
END

This statement errors out because of the update statement. Is this possible to do? If so, what is the correct syntax?

Thanks so much in advance for your help!

Cathy

 

[foxdev]

You are getting the error because CASE can only be used to return an expression, not execute a statement.

Use IF instead. Robert Bradley

http://www.foxdev.com/

Got extra money lying around? Visit:

http://www.agrainofhope.org

 

[Andel]

Hi, is the [60Days] a column or just a value?
Andel
maingel@hotmail.com

 

[allyne]

The [60Days] is a field.

 

[Andel]

UPDATE tblIrdbMonths
SET tblIrdbMonths.[90Days] =
CASE
WHEN tblIrdbMonths.[90Days] IS NULL THEN x
ELSE tblIrdbMonths.[90Days]
END



Andel
maingel@hotmail.com

 

[Andel]

Sorry, on the previous message, replace the x to whatever value you want, like [60days].
Andel
maingel@hotmail.com

 

[allyne]

Can you show me how I this in an IF statement. I am new to this and I can't seem to get it to work.

Thanks
Cathy

 

[allyne]

Thanks so much for all your help. Works like a charm!!!

Cathy