Subject | RE: [firebird-support] Re: Domain definition |
---|---|
Author | Daniel R. Jimenez |
Post date | 2006-01-06T05:06:50Z |
> > Hi,Hi Adam,
> >
> > Is it possible to have a domain definition for a field in a table
> where the
> > field is an integer of a set length?
> >
> > For example the data must contain 11 digits such as 20051225906
> >
> > Thank you
> >
> > Daniel
> >
>
> Yes,
>
> Use Check between 10000000000 and 99999999999
>
> Of course I am assuming it is unacceptable to have a number with fewer
> digits then 11, or with padded zeroes on the left.
>
> Adam
>
Not quite what I had in mind.
Correction I had nothing in mind, thus the question.
Definitely outsize the square :-)
Thanks
Daniel