Nice catch. Do you have any idea on how we could go around that problem?

Check with the char function, maybe the space in that string is not the char(32) space. Other than that, your code should work.

The normal answer is that the application is supposed to handle such a request as it is only a presentation issue. But I'm gonna ask you why you need...

even the service packs??

On which search??

Good point... I'll try to see to it .

No let's get you started on that .

HTH.

It depends on the number of calls to the function.. These would be called once each tops. When you use a function in another select >>

Select id, dbo.GetSomethingFromSomeTable(id) from...

Hmm, they seem to be cached on my server (as adhoc objectTypes and executable plans). The real performance killer is when you use a function that selects from a...

They'll serve the same purpose in the end but they are not the same thing, so they require different tables.

Also the users will surely request to check for only one...

BTW, see the split function as a flat loop. The break conditions are in the where clause and the output work is done in the select. The rank comes...

Nothing's changed really. It's the exact same problem with the same solution.

Just redo what you did only with another set of tables. Now you got 2 different results set...

Create a single script much like the proc where all 3 statements would be executed at the same time.

Just change NDays.PkNumber BETWEEN 3 AND 5

to NDays.PkNumber BETWEEN 2 AND 4

and that'll work.