SQL Syntax Queries in MOSS Search

Hi all,

I have been asked few times for best practices on writing SQL Syntax Queries with respect to MOSS Search. There are great articles in the MOSS SDK and MSDN on best practices. In case folks are not aware of these, here are couple of quick links:

Best Practices: Writing SQL Syntax Queries for Relevant Results in Enterprise Search: https://msdn2.microsoft.com/en-us/library/bb219479.aspx

Enterprise Search SQL Syntax Reference: https://msdn2.microsoft.com/en-us/library/ms493660.aspx

Hope that helps