Best Split UDF function with delimeter in T-SQL to return result as a

added by praveenbattula
6/4/2010 7:52:45 AM

0 Kicks, 42 Views

This is what the function I am using since many years to get the table of values in the given ID's which are separated by some delimiter. Simple to understand and see the example in the comments in below function. From the UI there are sometimes need of sending the data or ID's in the string format separated by a delimiter. So, in database, we need to grab them and apply some operations like with the ID's we need to get the records from a table. In this case, we need to use this UDF function. Everyone knows that inner joins are far better than IN clause or something else. So, what the approach I have taken here is......