i needed to play with data.

Declare @tbl table ( main_text nvarchar(200), Without_Roman_values nvarchar(100),Roman_values nvarchar(50) )

insert into @tbl (main_text)

select 'BHUVH III'

union

SELECT 'DEXY V'

UNION

SELECT 'JACK TONY VIII'

update @tbl

set Without_Roman_values = reverse(substring(reverse(main_text),charindex(' ', reverse(main_text) ,1), LEN(main_text))),

Roman_values = reverse(substring(reverse(main_text), 1, charindex(' ', reverse(main_text) ,1)))

select *,(dbo.ProperCase(Without_Roman_values)+ roman_values )as OutPut from @tbl