Just for fun: This is the sample data I tested with and the result I got: INSERT INTO @t(id, keyword, data) SELECT 1, 'Pet Store', 'Microsoft SQL Server' UNION ALL SELECT 2, 'SQL Server Database', 'Dinner at a New York Restaurant' UNION ALL

@billy: Check the forum, I posted my sample data I used to test with the results of my query. I am pretty sure I have it accurately, but others and yourself can test.

@ksuchlicki: That is because the word in that line is "Servers" not server. It properly replaced "Sql Server" first. @Billy: Not to be that guy, but check out your result on Line 7... TSQL is missing a tag. Also, the specs are sort of grey, but it

You learn something new every day... I didn't know that you don't have a leap year on the century years unless it is evenly divisible by 400.

What kind of logical read and scan counts were people getting? Does anybody have a great technique for really getting into query performance. My executions always lasted less than 20ms or so and my reads were pretty high, (though I was able to lower the

@ Billy: That looks like it works. But try adding this line to your table: UNION ALL SELECT 7, 'TSQL', 'Welcome to the Microsoft TSQL Pet Store.' Your output ain't pretty (like my grammar).