if the value of the field is "one" Display the message your value is one

[silviasalsa]

Hi I have to check a a field value in the database.
And output it in HTML
if the value of the field is "one" Display the message your value is one
if the value of the field is "two" Display the message your value is two

also

if the value of the field is any value Display the message your value "value of the field"
if it is null then NONE.

can you help me
thanks

[Dan_Bracuk]

The simplest way is with sql, but the details are db specific.

[dnyanesh_222]

i am facing this problem in business catalyst