INF doesn't sound like a number. My guess would be that it is NULL, but that you are using a program that displays NULL as INF. Exactly where did you see INF?

Note that default values are only applied for inserts where the field is not specified at all, i.e.

INSERT INTO SALG(KUNDE, PRIS) VALUES (:KUNDE, :PRIS)

would default VALBELOB to 0, whereas

INSERT INTO SALG(KUNDE, PRIS, VALBELOB) VALUES (:KUNDE, :PRIS, :VALBELOB)

would not default VALBELOB to anything, regardless of whether the parameter had a value.

HTH,
Set

--- In ib-support@y..., "mivi71dk" <Michael.Vilhelmsen@M...> wrote:
> Hi
>
> I just had a DB where I had a table with a field VALBELOB defined as
> NUMERIC(15,2) default 0.
>
> I contained the value INF
>
>
> What does that mean ?
>
> Michael