I am wondering which is the best way to add a new field that is searchable.

I want to test a condition eg.

Is this progam 'available' or 'not available'.

I was going to add a 'YES/NO' field, but then thought how would the user go searching this?

The other way of doing it was having a field that would contain the full text ie:

'available'
'not-available'

AND making this field searchable with a level of '1'.

Which is the 'best way' of doing this? I thought if I could have a pre-defined search query as a link in my menu then the Yes/No field may be better - if this is possible.

Any thought's would be appreciated.




------------------
Clint
----------------------------------
www.AffiliatesDirectory.com
Proud Supporter of Links SQL
----------------------------------