good one, tony

i think you'll find that MOD, LEN, and MID are not ANSI SQL functions

as for data integrity, that issue is moot when we're talking about incremental numbers, as pat suggested, you could have P00001, P00002, and then some wise guy inserts P00937, which fits the constraint, but is a time bomb waiting for the incremental numbers to reach that point...