I have a long series of digits (15) and I need to add three periods- one after the 5th character, one after the 9th, and one after the 11th. The field I want to update has the same number of characters every time and I need the periods and the same place every time. So I need:
Normally I would use LEFT() and RIGHT() but that seems difficult with this problem.
Marked as spam
Please log in to participate..