>(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.
>
>?
Steve,
You'll have to extract last name from cPerson first and than use it in your select
cLastName = Trim(Left(cPerson, AT(",", cPerson) -1) )
select assoc_id , lastname from timeuser where lastname = cLastName
--sb--