2. ASPRunnerPro General questions
  3. Possible to search for multiple items in the same field?
This topic is locked

Possible to search for multiple items in the same field?

 		1/6/2009 9:58:24 AM
ASPRunnerPro General questions
M
 Marty B author

Hello,

Is it possible with ASPRunner 6.0, using the advanced search, to search for the occurance of mulitiple items in the same field? For example, search a description field for WordX AND WordY.
If not, will ASPRunner.net allow this?
Thanks.
Sergey Kornilov admin 1/6/2009

You can modify SQL query in ASPRunnerPro to add a field alias.
select

Field,

Field as Field2

from ...
Then make sure both Field and Field2 appear on advanced search page. Now you can search this field for two values.
M
 		Marty B author 1/6/2009

Thanks Sergey,

This is a good solution.