468,257 Members | 1,410 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,257 developers. It's quick & easy.

Handling Null from a stored procedure

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
2 1542
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
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.

Similar topics

4 posts views Thread by Brendan McLoughlin | last post: by
9 posts views Thread by dtwilliams | last post: by
reply views Thread by kermitthefrogpy | last post: by
reply views Thread by zattat | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.