Posted by Good Man on 06/22/07 19:13

Good Man <heyho@letsgo.com> wrote in news:Xns99579A6044013sonicyouth@
216.196.97.131:


> or, alternatively:
>
> value 1 = "johnny"
> value 2 = "john"
> value 3 = "johnson"
>
> "SELECT * FROM tableName WHERE DudesName LIKE 'john'" would return only
> the 2nd value, but "LIKE '%john'" would return all three...
>
er, 'john%'

[Back to original message]