SQL Server 2005

For the life of me, I cannot figure out why the hell this...

WHERE
       CONTAINS (EventName,' "my" NEAR "chemical" NEAR "romance" ')

...returns 0 results, yet this...

WHERE
       CONTAINS (EventName,' "chemical" NEAR "romance" ')

...returns the correct records.

Why does "my" exclude any records?


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339456
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Reply via email to