Are there LEN and/or ISNUMERIC equivalents for setting constraints in the data partition for fields? There is a field that I'm in the process of adding. Even though the input should be all numeric initially, it should be treated like a string. Only one of my groups will use this field, but only if a specific request area is used.
I realize that I could create the field as an integer, but there is a point where I would have a trigger to change it to a string value, after the analyst is finished working with the ticket.
As for the LEN constraint, we want to set a minimum number of required characters if the field needs to be used.
Unfortunately, data-partitions are not designed to do such complex computations.