Formatting columns with a sql query

Question

Hey, I'm querying  a table for a reference number. This seemed easy but these  reference numbers are in the same cell as a description. Here is a example of a cell -  CARRY OUT WORK AS DETAILED IN P.I.M.I. NO.E6801 001 & COMPLETE CHECK SHEET E6801 001RA<br/>NOTE:.ENSURE PATOL SYSTEM SET TO....

All I want is the P.I.M.I. NO.E6801 001 number.

Is there any way of formatting a select query to only show these numbers? I don't really want to format the data itself as it will effect our document management system,  just the query result.

 B.T.W - I'm using Microsoft SQL server

 

Thank you.