(like is a reserved word in the UT search engine?)


cPerson has a value of 'DAVIDSON, RENEAE'.
There is a column in my table called lastname, one of the rows has a value of 'DAVIDSON'.
I have set exact off and set ansi off

My SQL is
select assoc_id , lastname from ;
timeuser where lastname = cPerson

I am having problems using the '%' an like and = operators because my target string is longer than the column value, so there is no match.

?