SQL Server Function that will return a text in HTML format -

i have csv file contains resume in plain text. need convert text field text html code.

for example:

plain text:

head  line2 line3 line4 

converted:

<p>head</p>  <p>line2<br /> line3<br /> line4</p> 

can sql server function can this? saw online tool http://www.textfixer.com/html/convert-text-html.php can similar function, need convert @ least 1300 rows of resume inside csv file.

thanks in advance!

i assume can put csv temp table or write against csv using open rowset or here idea of how encoding want. if more 1 resume exists replace partiton 1 partition uniqueresumeid

;with cteoriginalrownumber (     select        line        ,row_number() on (partition 1 order (select 0)) originalrownum            csvsource )  , ctereverserownumber (     select        line        ,originalrownum        ,row_number() on (partition 1 order originalrownum desc) reverserownum            cteoriginalrownumber )  select     case        when           originalrownum = 1           or (originalrownum = 2 , reverserownum = 1)           '<p>' + line + '</p>'        when originalrownum = 2 '<p>' + line + '<br />'        when originalrownum > 2 , reverserownum = 1 line + '</p>'        else line + '<br />'     end     ctereverserownumber order     originalrownum