When to use like comparison in Google Sheets?

You can use the Like comparison operator in the Query Where Clause. It enables the use of two wildcards in Google Sheets Query. The said two wildcards are similar to the asterisk and question mark which are common in use in other Spreadsheet functions.
For More Information Please Refer:

You May Also Like to Read: