Bela,

If you don't have to have an integer field, but instead just want a numeric wider than one digit write your constant like 000000 as xyz to get an N6 field.

>select ..., 0 ....
>
>
>I want the select statement to make the column of zero of integer type. But istead it gives me a 1 digit wide numeric column.
>
>Does anybody know the right syntax?