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

[ck9663]

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

[Mr aldo]

Thanks... I will try to get one working :)