Make your life easier and use SPT parameters

Update Table2 set PersonID = ?m.PersonID

Othervise upgrade to VFP9 and use STRCONV(,15)


>
>I have a SQL query that selects PersonID, which is a Binary - 10. I need to build a SQLQuery string to update a different table with various values, including the PersonID. How do I convert the PersonID to a string, suitable to include in my "Update Table2 set PersonID = ????"
>
>Thanks!