Michel,
What is the datatype of Client.Name? What are your indexes on client? Have you looked at the query plan? Is it doing index seeks and index scans vs table scans?
Update: Also SQLServer, like VFP, can not optimize a LIKE query if it starts with non-static text: %x can not be optimized with an index. x% can be optimized if you have a proper index on the column.
>This depends on the value entered. However, if I am not going parameterized, no matter the value, I will always get an optimized search result. But, for certain values, when going parameterized, it can take up to 8 to 50 seconds to find the same query.
>
>This has been discussed before. But, I really need to find what we need to adjust to avoid that.