Determines whether a given character string matches a specified pattern. A pattern can include regular characters and wildcard characters. During pattern matching, regular characters must match exactly the characters specified in the character string. Wildcard characters, however, can be matched with arbitrary fragments of the character string. Using wildcard characters makes the LIKE operator more flexible than using the = and != string comparison operators. If any of the arguments are not of a character string data type, SQL Server Compact 3.5 converts them to a character string data type, if possible.
The following example finds all telephone numbers that start with 9 in the Customers table.
SELECT [Company Name], [Contact Name], Phone FROM Customers WHERE (Phone LIKE '9%') ORDER BY [Contact Name]
If you are comparing an exact string (without wildcard characters), you should use = or != instead of LIKE. When using LIKE, SQL Server Compact 3.5 does not add padding to your match expression, and so queries against fixed-size columns will fail. If you use = or !=, the padding is automatically added.
You cannot query Image data type by using LIKE operator.