SQL regex- need help

I’m not very good at regex. Is there a way to get rid of the $ in ‘$100.00’ in SQL?

Hello,
One way to do this would be to use the REGEXP_REPLACE function described here: String Functions | Rockset Documentation

In your case you can try this:

REGEXP_REPLACE('$100.00', '^\$');

I hope this helps. Let us know if you have any other questions.

1 Like