Hi,

Thanks .  This solves my problem.  But there is another poblem with this.  In my application, all sql statements will be build by my front end.  In these statements "/" operator might be there or not.  Sometimes "/" operator may come more than once.  Please have a look of some examples which my application is generated.

IF .00 > 0 

begin 

  Select Result =  12000.00

end 

ELSE 

begin 

  Select Result =  0

end

IF 12000.00<6500 

begin 

  Select Result =  12000.00*0.0175

end 

ELSE

begin 

  Select Result =  0

end

Declare @Res int

Set @Res = 0

Select @Res = 12000.00

Select @Res as Result

Declare @Res int

Set @Res = 0

Select @Res = .00/(.00-.00)

Select @Res as Result

Now u suggest me how can I proceed.  If i get a error "Divide by zero error encountered" how can i make that error as "0".  My schedule is geting delayed because of this problem

Please help me in this.........

Bobby