Sounds like a concatenated field... Don't do this, its really poor data modelling.
Just use 2 fields. Inserting the db name/instance id as one value and the Sequence into a seperate fields...
If you need the data concatenated use a view or select it as field1||field2 ...
Just my .02




Reply With Quote