I have a stored procedure that works great in most cases. Except when the user searches with certain words. So, if the user searches for Sleep Habits - results are pulled back and ranked fine, same with the words Sleep and Diary - both pull up results. But if I search using the word Child, then I get results, but there is no rank (all 0%) - but Child Diary will pull back results with rank. Strange, right? I have pasted my stored procedure below...

Thank you so much, this is just what I was looking for!

:)

You made my day!

Hi, I would like to know if this is possible, I have a sql table that has a paragraph in a varchar field. I can query the database and pull this field in, it renders perfectly, except for the php code that is in the text. Can php be executed from within the results of a sql query, if so, how? (if it is relevant, I am using mssql, php and iis)

Here is the text (snip) - (how it looks in view source):
...