Sorry, but Chris's solution is probably the best solution you will get without posting the code that's causing you this heartache. We need to see the problem in order to...

Have you tried running sp_helptext on the function?

EDIT: Nevermind. Apparently it doesn't work on this function.

A little funny for the day.

I was having problems with the internet yesterday (and SSC). Then, later, my SO was responding on another forum to someone else who was having...

There's a very specific set of articles on SQL Server and LUN setups somewhere that I cannot find or remember the titles of that could help you out. I'm going...

Do you have a 2k8 server in the domain that VS2k5 is in? Have you tested the connection that way?

I'm wondering if there's a problem with VS2k5 seeing SQL Server...

Glad we could help.

In an effort to not scare you off of full-text, I've called in reinforcements to offer alternatives. I have, unfortunately, reached the limit of my knowledge in this subject.

Can someone with Full Text knowledge help out here: http://www.sqlservercentral.com/Forums/Topic1147434-1292-1.aspx#bm1147915

I think I scared the OP into thinking Full Text was Evil and useless, which is not what I was trying...

Good to hear. Glad we could help.

Glad I could help.

Remember, keep "pretty" on the user side. Don't worry about it for the backend stuff.

We're just using the variable as an example. you don't...

Where the 5 and 4 are in my code, these are the string lengths. If you want a variable strength length, then you just replace the numbers with LEN(Myfield)-1 and...

And I can't wait to complain about the correct answer to it! @=)

Ninja, I'm sorry, but this reply...

Ninja's_RGR'us (7/25/2011)

---

Brandie Tarvin (7/25/2011)

---

Actually, it's not that post, Ninja. There was another one that I responded to in the first few posts and the guy didn't want to listen to...