Regular Expresssion find Comma in Redshift Database
I have a query which is having ,
in lname column. I want to find the ,
and replace it with blank
. I want to use regex_substr but not getting any solution.
I have a query which is having ,
in lname column. I want to find the ,
and replace it with blank
. I want to use regex_substr but not getting any solution.