Boolean Parameters

Question

Hi All,

 Can I rename the Boolean Parameters from "Yes" or "No" to Any other naming Conversions?

For Ex : "Male" or "Female"

Thanks in Advance.

Pradeep

Answer 1

Unfortunately not.  The Boolean parameter is not flexible at all. Your best option is to go for a Text parameter with a value and a label, you can use a query as source:

select 1 val, 'Female' lbl
union all
select 2, 'Male'

---

SQL Server MVP, MCITP/MCTS SQL Server 2008
Check out my articles at BI: Beer Intelligence

Answer 2

You can do so in SELECT:

select name, sex = case sex

when 1  than 'male'

when 2 then 'female'

end

from MyTable