First of all you need to understand the purpose of Like keyword in SQL.
LIKE keyword helps you apply wildcard search in SQL/Oracle etc. e.g. If you want to find all the students for which name starts with P then query would be :
SELECT * FROM Students WHERE Name LIKE 'P%'
You can find a lots of examples at
MSDN Like Keyword[
^] also at
Tech on the net[
^]
Coming back to your question :
From your query it is evident that you want to list all the rows for which Name contains the string
"unique-char"
. The reason that you are getting 0 rows, is there may be no row for which name contains the string
"unique-char"
. Try to narrow the search. e.g
select * from Table1 where Name Like 'u%'
or
select * from Table1 where Name Like '%char%'
etc.
Hope this helps you.
All the best.