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

Thread: add a CAPS constraint

Threaded View

  1. #1
    Join Date
    Feb 2007
    Posts
    212

    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));
    or
    allter table EMP modify(NAME default upper(trim(NAME)));


    Thanks
    Last edited by jennifer2007; 02-19-2007 at 11: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