Converting update statement values dynamically in SQL Server

Question

I have a requirement to convert the value in the update statement dynamically in SQL Server.

For example, if I receive value as 'true', need to convert it as 'enabled' and 'false', then convert it as 'disabled'.

How I need to implement this in SQL Server ?

Answer 1

This isn't "conversion"; conversion means when you change the data type of a value, such as from a varchar to an int.

What you want here is simply a CASE expression:

CASE YourValue WHEN 'true' THEN 'enabled'
               WHEN 'false' THEN 'disabled'
END

You could also use an IIF(), which parsed as a CASE expression "under the hood":

IIF(YourValue = 'true','enabled','false')