Hope someone can point me in the right direction for this.
I need to create a user-defined function which in this case will compress out all non-alphanumeric characters and return that string. I want to apply it against a column in a table and put the results in another column.
There is some sketchy, incomplete info on how to do this, but I end up wasting a lot of time using trial and error to try and get this to work.
Documentation and examples would be really helpful.