search sql syntax I want all records not just 50 I am using FREETE

[cindy]

I am using sql syntax to execute a search query for a WSS 3.0 with Search
Server Express 2008 site

How can I change the number of Results returned to all rather than 50?

Can I do it in the following code or do I put something in the select at
bottom?

using (SPSite site = new SPSite(baseUrl))
{

using (FullTextSqlQuery query = new FullTextSqlQuery(site))
{

ResultTableCollection results = null;
query.QueryText = queryText;
query.ResultTypes = ResultType.RelevantResults;
query.TrimDuplicates = true;
query.EnableStemming = true;
query.IgnoreAllNoiseQuery = true;

query.AuthenticationType =
QueryAuthenticationType.NtAuthenticatedQuery;
results = query.Execute();

ResultTable relevantResults =
results[ResultType.RelevantResults];
if (relevantResults.TotalRows == 0)
{
lblQueryResult.Text="No Search Results Returned.";
}
else
{
ReadResultTable(relevantResults);
}

}

[cindy]

I found it

query.RowLimit = 500;
--
cindy