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
John Mitchell-245523
SSC Guru
Points: 148809
More actions
April 17, 2013 at 8:11 am
#1607261
Here's one way of doing it. It may not be the most efficient way, so you'll want to test for performance if you're going to use it in production.
SELECT Mynvarcharcol
FROM Mytable
WHERE Mynvarcharol LIKE '%[^,][^,][^,][^,]%'
John