...code my $year = param('year') || ''; # for testing only my $sql = "select name ,case year when '$year' then '$year' else '$year + 1' end from mytable where acc = '12345' and ( (year='$year') or (year = $year + 1) )"; ...code