SharePoint can search for content using the values in site columns, as well as performing free text searches. The official help page that describes this is at http://msdn2.microsoft.com/en-us/library/ms476494.aspx . This posting gives some more examples
Read More...
