Clause that can define a field as NOT ZERO

Lord.of.Wind · New User Joined: 17 Nov 2005 Posts: 60

Hi, all:

Is there a clause that can define a field NOT ZERO, if it is numeric ?

For example,
N_UPDATE_COUNTER SMALLINT NOT ZERO

If you know about this question, please kindly teach me, many thanks!

khannay2k · New User Joined: 24 Feb 2005 Posts: 28 Location: Bangalore

Lord.of.Wind,

Instead you can go for comparing the value in the field N_UPDATE_COUNTER SMALLINT with zeros, and if it yeilds it would satisfy your requirement.

A simple logic like N_UPDATE_COUNTER SMALLINT = Zeros.

Regrads.
Rajesh