After the 'LIKE'
To have an option to on-off and when it is on -
when the keyword 'LIKE' is typed or selected, put the 2 percentage signs sorrounded by single quotes and keep the cursor in between.
Ex:
Select * from t where FirstName Like '%%'
5
votes
Srinika
shared this idea
You can create a snippet wit the Snippets Manager filling in its fields as follows:
Shortcut: like
Description: LIKE ‘$CARET$’
Text: LIKE ‘$CARET$’