I'm assuming you meant picking off the characters from the list...

lcLast = SUBSTR(fullname, 1, AT(',', fullname))
lcFirst = SUBSTR(fullname, AT(',', fullname)+ 1)


>I have a field labeled FullName, in a database someone create awhile ago. The data format is last name, first name.
>
>Is there a way to do a LTrim to the ',' then do a RTRIM to the ',' ?