add a CAPS constraint Forums - Powered by vBulletin
Results 1 to 10 of 11

Thread: add a CAPS constraint

Threaded View

  1. #1
    Join Date
    Feb 2007

    add a CAPS constraint

    Hi Friends,

    How do I put contraints on my NAME column on EMP table so that all
    the data saved are all CAPS?

    Is this the correct syntax?

    allter table EMP modify(NAME check upper(NAME));
    allter table EMP modify(NAME default upper(trim(NAME)));

    Last edited by jennifer2007; 02-19-2007 at 10:40 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width