I need to get the fristname and lastname from the ownername1 field. I know it is something like this but I'm not sure how to incorporate this in the query. I tried but I keep getting sql errors:
(SELECT LEFT([ownername1], CHARINDEX(',', [ownername1]) - 1) LastName,
SUBSTRING([ownername1], CHARINDEX(',', [ownername1]) + 1, LEN([ownername1])) FirstName
If source = "PROPERTYTAX" Then
'Need to get lastname and frist and last name from ownername field
MySQL = "Select ownerename1 as firstname, ownername1 as lastname, locationaddress as address, locationcity as city, locationzip as zip from " & source & " where ownername1 = " & firstname
Thank you for your help.