Hi Thanks For the reply

ya i have 3 sql statements , it may return the value or may not return the value .If the 1st statement returns value then end the procedure by returning flag as "1" else go to 2nd SQL statement and it may return the value or may not return the value and if returns any value then end the procedure and return the flag as "1" and same in the case of 3rd...if all the 3 sql statements dont return the value end the procedure which returns "0" .... hope u got my problem...pls can u provide a proceedure for this?

Thanks in advance