I have a table with a AssetTag field, this has to be split into two fields.
ServiceTag and NewAssetTag
The current format of an old assettag looks something like this:
XX11111111 or XXXX1111 or 11111111 or 11111111XX
Where X=ServiceTag and 1=AssetTag
I would use Left, Right but the lenght of 1 always varies. Any ideas?
ServiceTag and NewAssetTag
The current format of an old assettag looks something like this:
XX11111111 or XXXX1111 or 11111111 or 11111111XX
Where X=ServiceTag and 1=AssetTag
I would use Left, Right but the lenght of 1 always varies. Any ideas?