Another solution as i believe there is no split function in sql

what i mean was use substring, patindex as mentioned etc.

example

declare @string varchar(max)

set @string = '0.9% NACL 250ML IV...

There are couple of solutions in your problem

1. You can loop to each record and split

2. put that split data in temporary table and make sure you preserve the id...