FROM Clause in SharePoint Foundation Search SQL Syntax
[This documentation is preliminary and is subject to change.]
Following the SELECT statement, you use the FROM clause to specify where to search for matching documents.
…FROM SCOPE()…
Remarks
In Search in Windows SharePoint Services, for the scope name, you can only specify SCOPE().
Note
This is not case-sensitive, so you can use SCOPE(), scope(), or Scope().