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.
From novice to tech pro — start learning today.