I want to be able to pull text from this string:

DABLennon,JohnDAQ1466 N Beatles AveDAL

=========================== ===========

Basically I want to be able to pull Lennon, John and put that into a FULL_NAME field & pull 1466 N Beatles Ave and put that into a field for address. Can anyone help me? Or point me in the right direction on how to do this?

I am using SQL Server 2005 on Windows XP