Dave,

I like that, good use of CLR. Now all I need to do is convert it to...

What do you mean by "can't"?

- You don't have visual Studio?

- You get an error when you...

I did have some more ideas:

1. Write an ActiveX control. But if you thought the code example for the web service was complicated then I don't think this is...

You need to realise that you can't save a file to the C: drive from within a web browser without user intervention because of security issues.

You will *always* get the...

Do you need to consider IPv6 addresses as well as IPv4?

edit: Just see the date on the original post! :blush:

lbabichenko 80114 (11/23/2009)

---

Simple way to do this without function

Create table #t(t varchar(10))

INSERT INTO #t VALUES ('1,2,3')

INSERT INTO #t VALUES ('3,4,5,11')

select * from #t

where t like '%1%' and t not like...

Richard,

No problem at all.

There's actually a big thread (almost 500 posts) here discussing the various methods of splitting strings that's worth looking at.

If you have the time, that is 🙂

Richard,

Try out Jeffs tally table method, if you haven't already, you should find it's even faster.

I got the following times on a 9000 element source string.

------------ XML Method ...

No need for a while loop to split delimited strings. See Jeff Modens Tally table article, linked to in my sig below, for some great tips on avoiding while loops...

I would advise against this sort of thing in a WHERE clause.

See here for the reasons why

So, if 7.0449 should be rounded up to 7.05, what is the largest value that should be rounded down to 7.04 or should all values > 7.04 be rounded up...

Talking of splitting. I'm surprised nobody has commented on this and it's use of recursive CTEs.

String Splitting[/url]

Needs to be shown the error of his ways 🙂

I would, but don't have...

Dave,

I think I see what you're trying to do.

Put an expression like this in the Visibilty->Hidden property for the field/row:

= NOT Parameters!ShowDetail.Value

Thanks, not seen...

Found someone who has already done something similar to what I was attempting to do.

See here

Hope this helps.