I need to validate data-entry on field IDProy just like:
alter table USUARIO
add constraint CK_IDProy
check (IDProy LIKE 'IC[A-I][0-9][0-9][0-9][0-9]')
using Data Dictionary (Progress 9.1D). I tried Validation button with LIKE but failed . . . I don't know using format field is enough . . . The problem is validating 3rd character to accept range A-I . . .
Need a dummies explanation :biggrin: THANKS
alter table USUARIO
add constraint CK_IDProy
check (IDProy LIKE 'IC[A-I][0-9][0-9][0-9][0-9]')
using Data Dictionary (Progress 9.1D). I tried Validation button with LIKE but failed . . . I don't know using format field is enough . . . The problem is validating 3rd character to accept range A-I . . .
Need a dummies explanation :biggrin: THANKS