Home Forums SQL Server 2008 SQL Server Newbies How to find values in a comma delimeted string with len>3 RE: How to find values in a comma delimeted string with len>3

  • April 18, 2013 at 1:17 pm

    #1607982

    labri (4/17/2013)

    Hi everyone,

    can you please help me with the following? I have a nvarchar column with data like this: ', 55,85,1,4,9888,6587,'

    How can I found the rows that include in their comma delimeted string, values with len()>3?

    I.e. if I had the following rows:

    ', 55,85,1,4,9888,6587,'

    ', 55,85,1,4,98,65,'

    I would like a statement that returns only the first row (beacuse it has values: 9888 and 6587) or only the values: 9888, 6587.

    Thank you in advance

    Which do you want, the entire row in which there is at least one numeric value with a length greater than 3 or just those numeric values from that row with a length greater than 3?