Re: why 's%' use index '%s' doesn't?

"Ed Wong" <ewong_at_mail.com> wrote

> When I use like operator, I found that search by 's%' is so much
> different from '%s'. Why is that and how to resolve this?

LIKE ('%s') is similar to:
On DOS/Windows: dir *s
On Unix : ls *s
(list all files ending with the character 's')

LIKE ('s%') is similar to:
On DOS/Windows: dir s*
On Unix : ls s*
(list all files starting with the character 's')

--
Billy