Recent content by evsy

I need to extract an email address from the free text field which will have other values in it. IE the field may contains: MY email address has changed to dave@bmi.com thanks I want to write a query to select dave@bmi.com I guess it involves mid and instr functions but am struggling to get...