Hi All,
2 questions :
1.i want to add a column(to the result pane) with the value "EUR" to all rows returnd by a SELECT clause (for example "select * from invoices").how do i do that ?
2.one of the colums supports one of the 3 values - 1,2,3
if the value is 1 - i want the column value in the result pane to be "male"
if the value is 2 - i want the column value in the result pane to be "female"

if the value is 3 - i want the column value in the result pane to be "other"

is there any way to do this mapping inside the SQL SELECT caluse ?

Thank you very much





Yuval Kronenfeld
Web Developer

__________________
Yuval Kronenfeld
Israel

Answers given below.

1. select *, "EUR" from invoices
        This adds a new column in the display pane as EUR for all resulted rows from the invoices table.

2. It should look something like the following.

select "************"=case
        when ************_COLUMN_NAME=1 then "Male"
        when ************_COLUMN_NAME=2 then "Female"
        else "Other"
    end

Hope that helps.

Cheers,

-Vijay G

Oops, I missed the from clause in my previous post.

select "************"=case
        when ************_COLUMN_NAME=1 then "Male"
        when ************_COLUMN_NAME=2 then "Female"
        else "Other"
    end
    FROM TABLE_NAME

-Vijay G

Thank you
working perfect !

Yuval

Yuval Kronenfeld
Web Developer

Thank you !



Yuval Kronenfeld
Web Developer