Advanced String Searching In SQL Server

Become a member! www.youtube.co...
Click here for 50% off a health check: training.erikd...
If you like what you see here, you'll love my advanced performance tuning training:
training.erikd...

[@Chompingbits]

Kronos Quartet Plays. Chanting circle of dudes "String to String!"

[@ErikDarlingData]

HAHAHA, oh no 😭

[@DanielMaenle]

My brain is mush now watching this

[@clerincg]

You may need that diaper if you continue to have problems with your colons 🤣

[@ErikDarlingData]

I might get one anyway so I can record longer videos.

[@caparn100]

Writing code like your first example is a sure way to have your brain file for early retirement! This will do the second example: SELECT s.string, a.FirstSymbol, b.SecondSymbol, SUBSTRING(s.string, FirstSymbol, SecondSymbol - FirstSymbol) AS mySubstring FROM #strings s CROSS APPLY(VALUES (PATINDEX('%[*!$?]%', s.string) + 1)) a(FirstSymbol) CROSS APPLY(VALUES (PATINDEX('%[*!$?]%', SUBSTRING(s.string, FirstSymbol, 100))+FirstSymbol-1)) b(SecondSymbol) ;

[@ErikDarlingData]

Are you sure? I get different results. Anyway, as usual, the real setup was more complicated, and yada yada yada.

[@caparn100]

@@ErikDarlingData Here is is with the additional position columns: SELECT s.string, first_search = SUBSTRING(s.string, a.first_position, 1), first_position = a.first_position, second_search = SUBSTRING(s.string, b.second_position, 1), second_position = b.second_position, SUBSTRING(s.string, first_position + 1, second_position - first_position - 1) AS sub FROM #strings s CROSS APPLY(VALUES (PATINDEX('%[*!$?]%', s.string))) a(first_position) CROSS APPLY(VALUES (PATINDEX('%[*!$?]%', SUBSTRING(s.string, a.first_position+1, 100))+first_position)) b(second_position) ; As far as I can see the column values give exactly the same results as those in your video. I'm pretty sure that PATINDEX is faster than selecting from a table of possible values. What was the real setup that made it more complicated?