Result field

• Post for FREE via your newsreader at post.usenet.com ****

Hi,

I have a table which contains a field (referred to below as "SCHEMA2"."FIELD2") with following format: NUMBER(9,3).

Now I create a view based on this and another table, which contains a case statement like:

CASE WHEN "SCHEMA1"."FIELD1" = 'A' THEN "SCHEMA2"."FIELD2" ELSE NULL END AS NameOfField

The resulting format of the field NameOfField in the view however now is NUMBER. I seem to have lost the (9,3) part.

How can I make sure that in my view the result field is also NUMBER(9,3)?

All help very much appreciated.

Patrick

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

• Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
  -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=