I know I'm missing something simple, probably not enough caffeine today. I'm trying to setup a computed column in a table that will strip all spaces from the string and replace all the non-alpha or numeric characters with an underscore (_). Here's some examples; First & Third would become First_Third, First/Third would become First_Third and Item # would become Item_.
Can someone suggest a way to do this please. Thanks in advance. Paul Buckley
