Function to get the address name

/*

po box 211

31 Lynnword ave
32 Allen Street
13 Miami Parade
88 John Street
PO Box 34608
4 Seabrook Avenue
128 Finlayson Ave
25 Clinton Ave

*/

ALTER FUNCTION [dbo].[fnAddressName]
(
    @fullAddress NVARCHAR(MAX)
)
RETURNS NVARCHAR(MAX)
BEGIN
  Declare @addressName  varchar(255),
    @addressNumber  varchar(255),
    @addressType  varchar(255) 

  --// Clean Up
  set @fullAddress = REPLACE(@fullAddress,'-',' ')
  set @fullAddress = REPLACE(@fullAddress,'/','')
  set @fullAddress = REPLACE(@fullAddress,'\','')
  set @fullAddress = REPLACE(@fullAddress,'(','')
  set @fullAddress = REPLACE(@fullAddress,')','')
  set @fullAddress = REPLACE(@fullAddress,'.','')
  set @fullAddress = REPLACE(@fullAddress,':','')

  set @addressNumber = (select LEFT(@fullAddress, charindex(' ', @fullAddress)))

  set @addressType =  (select RIGHT(@fullAddress, charindex(' ', reverse(@fullAddress))))

  set @addressName = LTRIM((select SUBSTRING(@fullAddress, (len(@addressNumber)+1),999)))
  set @addressName = LTRIM(reverse((select SUBSTRING(reverse(@addressName), (len(@addressType)+1),999))))

  --select  @addressNumber
  --select  @addressName
  --select  @addressType

  RETURN @addressName
END