| Subject | Problem with : where name like '%to' |
|---|---|
| Author | fb_cse |
| Post date | 2003-12-10T14:54:40Z |
Hello,
I've got a problem with a Select.
Select 1 :
select distinct name from person where name like 'toto';
Result -> toto
Select 2 :
select distinct name from person where name like 'to%';
Result -> toto
Select 3 :
select distinct name from person where name like '%to';
Result -> no record
Why Select 3 it's no good ?
I've got a problem with a Select.
Select 1 :
select distinct name from person where name like 'toto';
Result -> toto
Select 2 :
select distinct name from person where name like 'to%';
Result -> toto
Select 3 :
select distinct name from person where name like '%to';
Result -> no record
Why Select 3 it's no good ?