Hi,i would like to replace the first two characters (value is always
'33') of a text field with the value '0'. I tried the replace function
with a left function inside -> Replace(Field, Left(Field, 2), '0') and i
also tried it with a substring function -> Replace(Field
(Substring(Field, 1, 2)),'0'). The first case throws an error, the
second one works, but it does replace all '33' values in the field and i
need it to replace only the first two characters. Thank you so much in
advance for helping...