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?