>Hey Cetin, ne var ne yok?
>
>This is a VFP app with remote views that I'm converting for someone I'm mentoring and clients may or may not have clr installed. The UDF Sergey post on his website (ufn_mline) is working very well ( haven't pushed it for speed yet but in this app shouldn't be a problem)
>
>
>(I'm using VB in .net and loving the whole .net experience - going to Texas in Feb for a strataframe class - very VFE gibi )
>
>I can see in the future though that creating CLR UDFs is going to make a lot of things in SQL Server more fun.
>
>Oh, since I'm about to post this as a question in another thread, how do I pass a string of strings as a param to get the equivalent of VFPs INLIST. ( again, a remote view and I'm building a dynamic view parameter ) Can't use a correlated subquery in this case but I have a list of values
>
>SELECT * from jobs where INLIST(jobid,'00555','00444','00333')
>
>In T sql SELECT * from jobs where jobid IN ( and here I want something like ['00555','00444','00333'] )
>
>Sagol
>
Charles,
Review the original suggestion of Sergey in this thread. Or do a google search on fn_split.
There are better alternatives using XML though.
If it's not broken, fix it until it is.
My Blog