• Let me one guess (just a specualtion). Do you want values split to columns? If so, just use the udf like that:

    SELECT *

    INTO #test

    FROM (VALUES ('10.0||14.5'), ('2||34'), ('7.1||19'), ('4||11.7') ) v(val)

    ;

    SELECT val, v1.Item, v2.Item

    FROM #test

    CROSS APPLY (SELECT Item FROM dbo.DelimitedSplit8k(val,'|') WHERE ItemNumber = 1) v1

    CROSS APPLY (SELECT Item FROM dbo.DelimitedSplit8k(val,'|') WHERE ItemNumber = 3) v2

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]