467,915 Members | 1,292 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,915 developers. It's quick & easy.

Find in Set for MSSQL?

Mr aldo
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
  • viewed: 15498
Share:
2 Replies
ck9663
Expert 2GB
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
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.

Similar topics

7 posts views Thread by mj | last post: by
reply views Thread by Lenny Palozzi | last post: by
11 posts views Thread by ralphie | last post: by
14 posts views Thread by guswebb | last post: by
2 posts views Thread by =?iso-8859-1?B?RmFkpQ==?= | last post: by
kspiros
3 posts views Thread by kspiros | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.