Nov 10, 2001 #1 johnC2001 Programmer Nov 10, 2001 1 US I am trying to assign a check constraint to a column. It is supposed to ensure that each entry begins with the letter "R". Any suggestions? Any and all responses would be greatly appreciated. Thanks, John
I am trying to assign a check constraint to a column. It is supposed to ensure that each entry begins with the letter "R". Any suggestions? Any and all responses would be greatly appreciated. Thanks, John
Nov 11, 2001 #2 Kenrae Programmer Feb 7, 2001 174 ES Code: CHECK(substr(column,1,1)='R') Upvote 0 Downvote