I have run your code and it does what I require, as an addition how would I iterate through all records in the table checking the column and update to...
The asterisk could represent 1 or more characters and I need to expand all of the entries in that column that are like the above to 12 characters, by padding...