Context menus, disabling based upon keyboard state

Question

Hello, I'm fairly new to the use of context menus. While they are extremely handy, I can't seem to find a way to temporarily disable one. The basic idea is that by holding either the shift or alt key the use is able to change the context of the mouse events. The problem is, the context menu appears on a right click no matter what. Is there a way to temporarily disable the context menu, say on a key down event, then re-enable it on a key up event? Thx in advance.

Answer 1

You can use ISNULL function, if value is null it display 0

 

ISNULL(columnName, 0)

 

For further reference:

http://stackoverflow.com/questions/16667148/instead-of-null-how-do-i-show-0-in-result-with-select-statement-sql

 

Do let me know if it solves your problem. 

Answer 2

Use this code.

ISNULL(clmnName, 0)