Thanks PHV.
I am trying to replace this * with null and I am using this query
update test1 set column1 = replace(column1,'*[*]*' ,"",1)
Nothing gets replaced. Any ideas?
Thanks PHV. I am glad the query now prompts that it only updates how many ever rows that had * now instead of all the rows that the table has (it was giving this message earlier which got me confused)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.