Convert Case statement to use IN function

Database

Convert Case statement to use IN function

Hi.

I have a simple query; I need to convert a case statement

          CASE    When    REC_TYPE_CD = 0     or  REC_TYPE_CD = 2

                                 Then    'Act'

                             When    REC_TYPE_CD = 1 and VRSN_NUM > 99 and VRSN_NUM < 106   

                                 Then    'Pln'

                             When    REC_TYPE_CD = 3 and VRSN_NUM > 99 and VRSN_NUM < 106   

                                 Then    'Pln'

                          When    REC_TYPE_CD = 1 and VRSN_NUM = 2

                                 Then    'TgtV2'

          When    REC_TYPE_CD = 1 and VRSN_NUM = 3

                                 Then    'TgtV3'

          When    REC_TYPE_CD = 1 and VRSN_NUM = 4

                                 Then    'TgtV4'

           When    REC_TYPE_CD = 3 and VRSN_NUM = 2

                                 Then    'TgtV2'

          When    REC_TYPE_CD = 3 and VRSN_NUM = 3

                                 Then    'TgtV3'

          When    REC_TYPE_CD = 3 and VRSN_NUM = 4

                                 Then    'TgtV4' 

                             Else        'VNR'

                         END as "Version",

to use IN clause. I hope that would make this statement less complicated and improve performance.

please help me out with the solution. Also i have one more condition in where clause,

 ( REC_TYPE_CD = 0 and VRSN_NUM = 0 )    or  ( REC_TYPE_CD = 2 and VRSN_NUM = 0 )   

                        or  ( REC_TYPE_CD = 1 and VRSN_NUM = 2 )    or  ( REC_TYPE_CD = 3 and VRSN_NUM = 2 )  

                        or  ( REC_TYPE_CD = 1 and VRSN_NUM = 3 )    or  ( REC_TYPE_CD = 3 and VRSN_NUM = 3 )  

                         or  ( REC_TYPE_CD = 1 and VRSN_NUM = 4 )    or  ( REC_TYPE_CD = 3 and VRSN_NUM = 4 )  

                         or  ( REC_TYPE_CD = 1 and VRSN_NUM = 100 )  or  ( REC_TYPE_CD = 3 and VRSN_NUM = 100 ) 

                         ) 

Can i convert this too using IN clause ?

Tx.

Sheetal