-
Checking for uppercases
Hello all!
Is there a way, using a check clause, to see if part of an INSERT is all in uppercase? I'll be more specific...
Say I have a column that's CHAR(8). Which has to be composed of the first 4 are letters, last 4 numbers, like so AAAB9999. But it's important that the AAAB is in uppercase. I had wrote something along the lines of:
CHECK (UPPER(SUBSTR(column,1,3))....
But it doesn't work.
What am I doing wrong?
Thanxs for the help,
Steph
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|