At 03:51 26/12/2002 +0000, Gerald Brown wrote:

>Do you have examples of this?
>
>--- In ib-support@yahoogroups.com, "Ernesto Cullen" <ecullen@c...> wrote:
> > You can write before insert and before update triggers to accomplish
>this
> >
> > Ernesto Cullen
> >
> >
> > > Is it possible to create a field that will default to UPPER CASE
> > > regardless of how the user enters the data?
> > >

create trigger bi_atable active before insert position 0 [also...before
update trigger the same]
as
begin
if (new.YourColumn is not null) then
new.YourColumn = upper(new.YourColumn);
end

heLen