if...then 1

[sexydog]

can i use an if then in the where clause

i want to select amount but if it is ='' then i want to replace it with amount = 0.00

 

[dbtech]

U can make use of CASE Statements.

Please post your full query.

Anway this is how its done

SELECT Amount FROM tablename
WHERE Amount=(CASE WHEN Amount ='' THEN 0 END)


dbtech

 

[VJJ]

try isnull as in:
select isnull(amount,0.0)....