inline sql to replace case

[timscronin]

Is there any way to replace the following case with some type of in line sql

prn =
case
WHEN special_flag = 'PRN' THEN '1'
else '0'
END

lookin for an immediate if type

 

[k108]

Yes, write a function or stored procedure with your case statement and call the function or stored procedure inline.