----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: Senthil-Maverick Message 1 in Discussion hi i have a stored Procedure to retrun an Out put parameter. The Qry is like this : Select @VarCallCount = (sql1) IF @VarCallCount<>null Set @CAllCOUNT = @VarCallCount Else Set @CAllCOUNT =0 Select @var = ( sql2) If @var <>null Set @CHATCOUNT = (@CAllCOUNT + @var ) Else Set @CHATCOUNT = (@CAllCOUNT ) Select @varFInal = (sql3) IF @varFinal <>null Set @FINALCOUNT =(@CHATCOUNT + @varFinal) Else Set @FINALCOUNT = (@CHATCOUNT ) Set @out= @FINALCOUNT Return @out i have declared all the variables and for the simplicity i have sql1, sql2 and sql3 . Now my Problem is when i use (using NULL STRING ) IF @VarCallCount<>'' Set @CAllCOUNT = @VarCallCount Else Set @CAllCOUNT =0 I am not able to get the OutPut value. But when i use IF @VarCallCount<>null Set @CAllCOUNT = @VarCallCount Else Set @CAllCOUNT =0 i am able to get The out put value when i use null and not nullstring '' . why is this so ?? ,,,,, Senthil ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/BDOTNET/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
