I innocently wrote this SQL SELECT statement to query all rows that have column value started with "[summary]": select * from MyTable where Description like '[summary]%' Then I was wondering why I could get a lot of rows returned and none of them started