Hey Guys,

Thanks for the huge response and fun here. I didnt expect a 4page posts for this topic 😎

The query which has vendor_id etc was just an example, it is...

pkan (9/4/2009)

---

Hi sudhanva,

I hope you also must have learnt from Ken McKelvey about how to make it more understandable for other's to reply to your query so as to make...

Why No?

Can anybody provide some links/info on this?

Hats off to you Ken McKelvey. 😎

One more question, will there be any performance issue using REPLACE function?

Hey experts, anybody has solution for this???

How to search for a pattern like mentioned in my question above??

changing : [anyword anyword] to [anyword OR anyword]

or : [anyword AND anyword anyword]...

case will not help here. Please send a sample query.

kruti (9/2/2009)

---

I hope i could get...

Yeah, currently i have Full Text Index on base tables.

But querying those tables everytime is taking time. So thought of having VIEW.

Any other work around?

Thanks & Regards,

Sudhanva

No hopes 🙁

Suppose, i have a composite key in the VIEW, but can i have a composite for creating FULL TEXT INDEX. No, i guess. I think, FTIndex requires a...

Hi,

Thanks for the reply.

I cant pull out the unique row, since the data contains repeated rows.

I need something like rownumber(), to get a unique column on the VIEW.

I hope...

Hi,

Thanks for the reply.

Bob Hovious (8/11/2009)

---

I would also like to ask why you are insisting on a solution that uses CONTAINS. You know that you have a solution...

Bob Hovious (8/6/2009)

---

This sounds like a homework assignment to me. What problems are you having when you try to do it? How are you...

Hi,

Thanks for the reply.

I need a solution to get the count using patindex/charindex. I know how to achieve it using count(*).

And the number of words is not fixed.

Please help.

Thanks...

That didnt help to find the solution for this post.

Help me.

:sick:

That didnt help to find the solution for this post.

Help me.

Matt Wilhoite (7/29/2009)

---

3) There is no criteria for what they can search for. They could search for "all your base" as easily as search for "fuel efficient"

So the...