SQL Full text search error trapping 1

[McLennanN]

I need to do a full text search given a word input by a user. However for simple words like 'the' the full text search returns the error
'The query contained only ignored words.'
How can I trap this error and return the results of an alternative query.

 

[Cagliostro]

the sintax is
select somevalues from sometable
where somecolumn like '%xxx%' John Fill

ivfmd@mail.md

 

[McLennanN]

You do not understand.
I want to use full text search. The problem is
if the following search is run
SELECT Indexes from IndexTable where
CONTAINS(Indexes,' FORMSOF (INFLECTIONAL,"the&quot

the error 'The query contained only ignored words.' occurs which I would like to trap so i can return the results
of

SELECT Indexes from IndexTable where Indexes like '%the%'

instead. Does anybody know how to trap the error return in Transact SQL?

 

[Cagliostro]

try this one. Maybe it will help.
select ..... from ... where column in(select '%' + column + '%' from .....) John Fill

ivfmd@mail.md