• You may hard code it as well

    select * from [Temptable]

    where namesrt in (100,599

    , case @NAME when '410' then 410 when '430' then 430 end

    , case when not (@NAME in ('410' , '430') ) then 410 end

    , case when not (@NAME in ('410' , '430') ) then 430 end

    )

    regards

    Serg