By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,756 Members | 1,760 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,756 IT Pros & Developers. It's quick & easy.

Handling Null from a stored procedure

P: 3
Hi ,

I am fetching a column through stored procedure which is having a NULL value.

Instead of fecthing NULL it is giving me some junk value .

Can some one please tell me how to get NULL?
Jun 20 '07 #1
Share this Question
Share on Google+
2 Replies


P: 2
Hi ,

I believe this mignt help.

A NULL has no value what so ever and is neither greater than or less than "Y" or anything else. The best way to demonstrate this is to use the VALUE function on the field and assign it a value then you can say <> "Y"

e.g (VALUE(column-name, ' ' ) = 'Y')
Jun 20 '07 #2

P: 3
Hi ,

I believe this mignt help.

A NULL has no value what so ever and is neither greater than or less than "Y" or anything else. The best way to demonstrate this is to use the VALUE function on the field and assign it a value then you can say <> "Y"

e.g (VALUE(column-name, ' ' ) = 'Y')

Hi,

First of all thanks for the reply..
but my problem is that i can't change anything in stored procedure..
the output column is binded while calling the stored procedure and that column is NULL in DB , so it should return be '0' as the output column type is integer but instead if this some junk valu is coming, can you suggest something for that?
Jun 21 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.