Using replace to update/change two values

[webmagic]

Hi,
I am working with a table that sends an "S" in a field. I can change the "S" to a "1". But where there is not an "S" in the table I would like a "0". Here is what I am using now:

update_flag: Replace([OFF_MILL_IN_SPEC_FLAG],"S","1")

I have tried several things, and nothing-is it possible to do it this way?

Thank you in advance.

 

[rainman89]

do iif([off_mill_in_spec_flag]="S", "1", "0")

 

[webmagic]

Perfect-Thank you!