lcStr = "Due to Other NG- Philippines"
? LTRIM(STRTRAN(lcStr, "Due to Other NG", ""), "-", " ")

>How do I extract from a string and remove the Due to Other NG using SELECT?
>
>i.e.
>Due to Other NG- Philippines
>Due to Other NG -Canada
>Due to Other NG - Australia
>Due toOther NG - United Kingdom
>Dute to Due to Other NG - Japan