More guidance is requested . I have a field in Select query solicitors, which produces the name of the solicitor and the telephone number .My requirement is to be able extract only the solicitors name . I have tried various combination using left function and is numeric to remove the numbers. The output format is always the same Watt Jones : 23473058. If more details require please advise .
Any assistance would be appreciated .
Regards Ypma
Any assistance would be appreciated .
Regards Ypma