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