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...

GilaMonster (7/25/2011)

---

SQLRNNR (7/25/2011)

---

GilaMonster (7/25/2011)

---

mtillman-921105 (7/25/2011)

---

Too many of these posters don't realize the level of expertise that they are getting here. Maybe you all need more intimidating titles like "Grand...

rbond 51820 (7/25/2011)

---

We are converting the date to string because the end users tend to "freak" when they see the system datetime with hh:mm:ss rather than just the date only...

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 me, Gus, and...

Dynamic SQL is when you populate a variable with a SQL query or another stored procedure. Read up on sp_executesql when you get a chance, so you understand what can...

😛

@=)

I have to agree with Gus & Ninja. Yes, you can do it, but there are so many things that can go wrong with that method (like accidentally deleting the...

Why are you converting your dates to strings?

I have always had problems with BETWEEN dropping records on me, so I never use it. I always go this route:

SH_ACCT.open_dt >= dateadd(mm,datediff(mm,0,dateadd(mm,-2,getdate())),0)...