Thanks. I was thinking there is a 'SQLish' way (faking out thing with like or whatever), but I guess not. Your solution is right on the money! :)



>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
>
>