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
No one has answered this question yet
Check out similar questions: