I was looking at REPLACE() to do this, but I’m not sure. I have a field called exp_days that shows data like this:
exp_days
+31 days
-102 days
-10 days
+25 days
And I’d like to remove every instance of ’ days’ including the space before it and keep the positive or neg number. Not sure how to search a string like that, perhaps using LIKE?