why do you have two indexes with the same leading columns?

IX_tab3- nonclustered located on PRIMARY col5, col6, col7, col4

IX_tab3_5-nonclustered located on PRIMARY col5, col6, col7, col4, col2

Surely the first one...

If you want the same behaviour then use;

Select * from emp where CONTAINS(name , '"*varun*"')

you may also want to have a look at using CONTAINS for Full-Text searches as it...

Are those queries in the first post the actual queries or have you modified them?

The big difference between Like and FreeText is that FreeText will search for whole words, wheras...

Asuuming that this is on a development sever - you could try and rebuild the catalog

You can right-click on the catalog and click properties and under the population status - it will say 'populating catalog' if the catalog is building.

Has your Full-Text Catalog been fully built?

Are you able to provide some sample data showing the different results from the queries?

I perfer to use triggers but a couple of suggestions;

You could modify your insert procedures to log all the inserts to an audit table after they have written to the...

There may be an error in the function, can you post the code for that?

That's true,

Sorry I just re-read my code and worked out your were picking up on my 'Test' code that I had left in there accidently. I have edited...

It was not in the original code, I just assumed that the poster was looking to extract the string between '[' and ']'

But I guess you know what they say...

sorry read the code wrong this shoud work;

SELECT SUBSTRing

(description,

charindex ('[', description) + 1,

charindex ( ']',description ) - charindex ('[', description) -1

)

FROM PublishItem

WHERE description like '%Doc No%' and description...

What is the error message?

At a guess, is it complaining if it can't find '[' or ']' in the string as this would cause the substring to...

Sorry I don't have any definite answers but maybe someone else does.., unfortunately this is one of the problems that arise when using an EAV model to store all the...

I thought 40 Lakh = 4 Million...

This should work

(note: completly untested)

SELECT state, SUM(total) AS Total FROM (

select state,count(*),0 as total from tAccount

Where datestamp >= '9/1/2009' AND datestamp <= '9/30/2009'

group by state

UNION

SELECT...