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
|