Tell me more ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

Iam having table TestTable where i have few columns say

            C1  | C2 | C3 | c4
            'ab'|  1 | 09 |          //CASE1 [ must return 1]
                |    |    |          //CASE2 [ must return 0]

I want to check if data in that table is present if any of columns data is present i want my value to be 1 , if all the columns are blank(No Data) then i want my value to be 0

Can any one help, i have no idea expect this condition in front of me.

share

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.