>>select * from myTable where Condition1 OR Condition2 >>>>is the same as
>>select * from myTable where Condition1 >>UNION >>select * from myTable where Condition2>
CREATE FUNCTION [dbo].[udf_List2Table] ( @List VARCHAR(8000), @Delim CHAR ) RETURNS @ParsedList TABLE ( --*[2013/01/16 20:55:53] ndragan - replaced SQL_Latin1_General_CP1_CI_AS with database_default item VARCHAR(8000) COLLATE database_default, ListOrder Int ) AS BEGIN DECLARE @item VARCHAR(8000), @Pos INT, @nT INT SET @List = LTRIM(RTRIM(@List))+ @Delim SET @Pos = CHARINDEX(@Delim, @List, 1) SET @nT = 1 WHILE @Pos > 0 BEGIN SET @item = LTRIM(RTRIM(LEFT(@List, @Pos - 1))) IF @item <> '' BEGIN INSERT INTO @ParsedList (item, Listorder) VALUES (CAST(@item AS VARCHAR(8000)), @nT) SET @nT = @nT+1 END SET @List = RIGHT(@List, LEN(@List) - @Pos) SET @Pos = CHARINDEX(@Delim, @List, 1) END RETURN END