17 Mar 2008 at 22:26 #1 Da[]San Da[]San Associate Joined 20 Oct 2002 Posts 1,616 Location North West Hope you guys can help me with a query that I need to write. I have a query which produces a list of parts with a prefix of HP- , what i need to do is replace the HP- with H3- any ideas?
Hope you guys can help me with a query that I need to write. I have a query which produces a list of parts with a prefix of HP- , what i need to do is replace the HP- with H3- any ideas?
17 Mar 2008 at 22:43 #2 Da[]San Da[]San Associate OP Joined 20 Oct 2002 Posts 1,616 Location North West Sussed it, used the Replace Function