Home Forums SQL Server 2008 SQL Server Newbies Retrieve second of three values separated by spaces RE: Retrieve second of three values separated by spaces

  • December 17, 2012 at 5:49 pm

    #1569331

    Using Jeff Moden's splitter[/url] you can do this...

    DECLARE @spitme TABLE (Item varchar(40));

    INSERT @spitme VALUES ('HEYE-B Euro-IPA 69793'), ('HEYE-B RFE-IPA 70940');

    SELECT s.Item

    FROM @spitme val

    CROSS APPLY test.[dbo].[DelimitedSplit8K](val.Item,' ') s

    WHERE ItemNumber = 2

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001