I am using a regular expression as follows:
SELECT * FROM myTable WHERE Description LIKE 'some text'
This easily detects an asterisk or squote character that isn't enclosed in brackets. What I'd like to do is create a single regular expression that adds square brackets around a "naked" asterisk or squote character. I could do it with two discreet regex calls but I'm hoping there's a smarter way to build the regular expression such that if it finds any character in the middle part that it is automatically enclosed in square brackets.
Experts Exchange (EE) has become my company's go-to resource to get answers. I've used EE to make decisions, solve problems and even save customers. OutagesIO has been a challenging project and... Keep reading >>