My question is regarding a case insensitive query. Is there a way (other than triggers) to force a value that goes into a field to be all in one case -- either UPPER or LOWER? The database is in Oracle.

    Requires Free Membership to View

A similar way is to use a CHECK constraint on the column for UPPER(column).

This was first published in March 2004

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.