I'm trying to run a query that returns a VARCHAR field that may or may not contain the characters ***. If it does contain that, I basically want to hide the 3 characters and display the rest of the string. I was trying to get the syntax below to work, but for some reason it doesn't. Any help please? Thanks!
SELECT Field1 = REPLACE(Field1,'***','') AS Test FROM `tbl_Data` WHERE ID=33