user name with hyphen causing error
when this user tries to access the storefront he's getting the following error:
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Regan' where customers_id = '893'' at line 1
update osc_customers set customers_username = 'Barry O'Regan' where customers_id = '893'
[TEP STOP]
when I remove the hyphen it works fine.
Any ideas for a fix other than chaging his name?
Thanks!
David