how to split value form field and drill down list

[lonjovy]

So,please help me to split value from table like below

field A has value below
13974;14098;14237;14269;14317;14319;14392;14393;13 257;13983;13820

and i need to split and down value in row like below
file B
13974
14098
14237
14269
....
please help me to supports
many thanks

[viktorka]

You may try to play around te code below, however, if you pass this string to SQL from VB, C++ or other, it could be easier to split it before passing it to SQL.

declare @str as varchar(50)
set @str = '13974;14098;14237;14269;14317;14319;14392;14393;1 3 257;13983;13820'

while charindex(';',@str)>0 begin
select left(@str, charindex(';',@str)-1)
set @str = right(@str,len(@str)-charindex(';',@str))
end