SQL Query - How to find a field with two or more identical characters in it

I am using SQL Server DB and I would like to write a query that will search for fields with two or more slashes in it, let's say we have the following lines:

1. abc/def/g
2. abcd/efg
3. a/b/c/d/e/f/g

      

So it should return 1st and 3rd lines! What's the easiest way to do this?

Thanks in advance!

+3


source to share





All Articles