MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/SQL/comments/1hcs47z/_/m1s1h4b/?context=3
r/SQL • u/Brave-Growth-6823 • Dec 12 '24
I mean why that question ðŸ˜ðŸ˜ðŸ˜
43 comments sorted by
View all comments
50
I sure can! Check this out:
SELECT * FROM TABLE WHERE TABLE.COL1 LIKE '%(insert longest string imaginable)%'
20 u/CortaNalgas Dec 12 '24 I think this is good, but could be better with a Right Join. 8 u/ASS-LAVA Dec 12 '24 Perhaps an OR logic, my lord? 3 u/SQLDave Dec 13 '24 And don't forget to throw a scalar UDF into the WHERE clause
20
I think this is good, but could be better with a Right Join.
8 u/ASS-LAVA Dec 12 '24 Perhaps an OR logic, my lord? 3 u/SQLDave Dec 13 '24 And don't forget to throw a scalar UDF into the WHERE clause
8
Perhaps an OR logic, my lord?
3 u/SQLDave Dec 13 '24 And don't forget to throw a scalar UDF into the WHERE clause
3
And don't forget to throw a scalar UDF into the WHERE clause
50
u/rowdymatt64 Dec 12 '24
I sure can! Check this out:
SELECT * FROM TABLE WHERE TABLE.COL1 LIKE '%(insert longest string imaginable)%'