Oracle 8.1.7.4
I know I'm using characters for my range.

partition by range(accesstype,language)
(partition p1 values less than ('EZ','EZ') tablespace typemenu_part1,
partition p3 values less than ('EZ','FZ') tablespace typemenu_part3,
partition p2 values less than ('IZ','EZ') tablespace typemenu_part2,
partition p4 values less than ('IZ','FZ') tablespace typemenu_part4,
partition bad_part values less than (MAXVALUE,MAXVALUE) tablespace
typemenu_part3
)

I'm getting
select distinct accesstype,languagefrom asset.admin_typemenu_temp partition
(p1)
returns
EXTERNAL ENGLISH
EXTERNAL FRENCH

select distinct language,accesstype from asset.admin_typemenu_temp partition
(p2)
returns
INTERNAL ENGLISH
INTERNAL FRENCH

How come nothing in partitions p3 & p4?

Mike
[Email Address Removed]Oracle LazyDBA home page