Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Repeating substring in a string
- Thread starter ASCII
- Start date
There is no built-in function that returns the number of occurrences of a given string ("LIKE"
within another string (your SQL statement). What are you really trying to do, just determine whether or not "LIKE" occurs 2 or more times, or are you really doing more than that? Do you need to ignore LIKEs within quoted literals? I can write you a quick function, but I need more specs
within another string (your SQL statement). What are you really trying to do, just determine whether or not "LIKE" occurs 2 or more times, or are you really doing more than that? Do you need to ignore LIKEs within quoted literals? I can write you a quick function, but I need more specs - Status
Similar threads
- Locked
- Question
- Locked
- Question