How to get only character data from complete name

[#1]

Hi,

I have one column values in sql table as

Name= 32456 Mr Adam Jones

I need to get Name= Mr Adam Jones in Straight table. Could anyone help me how to write expression or script to get obly name part.

Thanks.

[#2]

Thanks for your answer and it's working

[#3]

Thanks for your answer