Home Forums SQL Server 7,2000 SQL Server Newbies Extracting Rows from Delimited Strings RE: Extracting Rows from Delimited Strings

  • April 25, 2008 at 6:37 am

    #807112

    My first thought is, are there any rows in the raw_data table where the raw_payload column doesn't contain a comma, or are NULL?

    SELECT raw_payload

    FROM raw_data

    WHERE raw_payload IS NULL

    OR CHARINDEX(',', raw_payload, 1) = 0

    ? :ermm:


    Ade

    A Freudian Slip is when you say one thing and mean your mother.
    For detail-enriched answers, ask detail-enriched questions...[/url]