E
Edward
Hello. I would like to update a field in a table by selecting the first 4
digits which match a pattern and update the field with replacement of 6
digits.
for example:
the number 1000009200000 would become 09001000920000
in this case the pattern is as follows:
1000 | 009200000
replaced as
0900100 | 009200000
I know it might go something like this:
update TableName,
set FieldName = Left,6,0900100
where FieldName = Left,4,1000
(or I'm way out to lunch ;-))
The Field is text.
Any help is very much appreciated.
digits which match a pattern and update the field with replacement of 6
digits.
for example:
the number 1000009200000 would become 09001000920000
in this case the pattern is as follows:
1000 | 009200000
replaced as
0900100 | 009200000
I know it might go something like this:
update TableName,
set FieldName = Left,6,0900100
where FieldName = Left,4,1000
(or I'm way out to lunch ;-))
The Field is text.
Any help is very much appreciated.