By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,415 Members | 1,568 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,415 IT Pros & Developers. It's quick & easy.

Find in Set for MSSQL?

Mr aldo
P: 15
Hello...

I have been searching for about an hour, Google and this site but I have yet to find it.

I have been trying to find the MSSQL equivalent to the MySQL function FIND_IN_SET(str, strlist) which can be used in the WHERE clause. So if you have a str of 1 and a strlist of 1,2,3 it would return 1, or a bool of true because it is in that list.

I have been trying to find it, but no one has actually answered the question... I have not seen a CREATE FUNCTION for FIND_IN_SET, or even something that remotely helps.

If anyone can help it would be greatly appreciated
Dec 24 '08 #1
Share this Question
Share on Google+
2 Replies


ck9663
Expert 2.5K+
P: 2,878
Depending on what you need or how you will use it, you can use one of these:

IN()

or

CHARINDEX()

or

PATINDEX()

or

LIKE

Happy Coding!

-- CK
Dec 24 '08 #2

Mr aldo
P: 15
Thanks... I will try to get one working :)
Dec 24 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.