>Hi All! How do you extract certain parts of a string. Like I want to replace the first three digits of a field with something. ie. 50-1020 with 95-1020
>Anything that begins with 50- I want to replace it with 95-
>
>Thanks in advance for your help!
>
>Joe
Joe: You can use
REPLACE MyField WITH "95-" + SUBS(MyField,4)
or also you can use
REPLACE MyField WITH STRTRAN(MyField, "50-", "95-")
Selects the sentence that but to you agrees
Luis María Guayán
Tucumán, Argentina
________________________________
SysOp de
www.PortalFox.comNada corre como un zorro
________________________________