I am new to this field and facing problems in writing query- I am having one table tbfeeconfig- having fields Particulars,Amount and excludeGirls, values as follows-:
Particular     Amount  xcludegirls
Admission Fee   100.00    0
Collg Dev Fee   100.00    0
Regis  Fee      100.00    0
Tution fee      100.00    1

My problem is I have to pass 0.00 in place of 100.00 
in Amount where excludeGirl=1,

I used coalesce() function which is of no use.
Can anyone help me how can i pass value 0 to column 
amount when excludeGirls==1.

Please help!!!