I was trying to find out if there is a way to check multiple
columns when using the CONTAINS condition in SQL 7.0.

I know i can do one column and I can do all the columns that
are full-text indexed, how do i do more than one but not all!

select * from table where contains (table.column1,'"foo1" and "foo2"&#39
and
select * from table where contains (table.column.*,'"foo1" and "foo2"&#39
do work...
but i need to do something like
select * from table where contains(column1,column2, '"foo"&#39