LIKE question

[killboy]

Hi there.I've been reading about the LIKE condition, and it says that it can be used with % or _My question is: what happens when I use it without these signs?For example:

select id from user where name like '[some string here]'

I've run it and it returns a normal result, but I want to know what is it used for when I use it without those signs?Thanx.

[Synook]

In that case it is the same as =. So

select id from user where name like '[some string here]'

Is the same as

select id from user where name = '[some string here]'

[killboy]

Oh, I had the idea that the LIKE written like that, executed a case-insensitive query; but I wanted to be sure.Thanks for the reply