Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 219
  • Last Modified:

How to display 0 in int column as blank

I have table meds contains field act of int type.
The field act which contains 0 and >0 values. How can i display 0 as blank and other values as actual values.
0
searchsanjaysharma
Asked:
searchsanjaysharma
2 Solutions
 
Pratima PharandeCommented:
select case when act >=0 then act else 0 end as act from meds
0
 
Scott Fell, EE MVEDeveloper & EE ModeratorCommented:
You could cast act as a character and if it is 0 make it ''. But I think this is probably best to do on the front end using your serverside code or or javascript/jquery.
0
 
searchsanjaysharmaAuthor Commented:
tx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now