On Tue, 30 Nov 2004 17:59:47 -0500, Ted Roche <tedroche /AT/ tedroche D.O.T com> wrote:
> On Nov 30, 2004, at 5:36 PM, Nancy Folsom wrote:
> > My brain is vapor-locking how to do this (or if it can be done). For
> > example,
> >
> > CREATE SQL VIEW AS SELECT 0000 as nCol, cTable.* from cTable
> >
> > nCol is always 1 digit long. I need a larger capacity column. Can it
> > be done, and if so, how? TIA.
>
> It displays a single zero, but LIST STRUCTURE should show you N(4).
That's what I see, too, and as of 9, you'll be able to use "SELECT
CAST(0 AS N(4))" to make it more explicit.
©2004 Garrett Fitzgerald |
