Subject | Re: [ib-support] Upper case for a field |
---|---|
Author | Milan Babuskov |
Post date | 2002-12-26T15:58:49Z |
Gerald Brown wrote:
Insert into table(regular_field, always_upper_field)
values (:rfparam, upper(:aufparam));
HTH
Milan Babuskov
http://fbexport.sourceforge.net
> Is it possible to create a field that will default to UPPER CASEYou can use UPPER function in your INSERT statement like this:
> regardless of how the user enters the data?
Insert into table(regular_field, always_upper_field)
values (:rfparam, upper(:aufparam));
HTH
Milan Babuskov
http://fbexport.sourceforge.net