Hi all,
I have a text field in a table with 50000 records.
I need to update data in one field by adding a dot (.) after the third character if more than three characters exists.
If the value in the field has only three characters then no need to add the (.).( i.e. so that no (.) ending point exists.)
Note:
A leading zero exist in some data fields.
How can I do this?
I was thinking of an update query but don't know how to do it.
Khalil