This is just a short copy of a SP im using in SQL server... now the problem appears if there will be to many parameters involved.. (HUGE query)
My main problem is how to reduce the length of the query..
So, instead of doing it like this..:
AND (((xxxx like 'yyyy%') OR (xxxx like 'zzzz%')))
I was thinking of doing like this..:
xxxx IN ('yyyy%', 'zzzz%')
But when im using the "IN" im not able to use the % (Cause sometimes strings are weird) and no result is shown, but when removing the % i get the satisfying result, not depending on Case sensitivity which is perfect, but still...
And im really really lousy to explain things, hope its ok anyways
No, IN cannot be used as a substitute for 'like', it will not work. You could try looking at applying a string function on the column side, e.g. WHERE substring( mycolumn, 0, 4) IN ( 'stri', '1234', 'etc.' )