Subject | Case insensitive select |
---|---|
Author | willfordkc |
Post date | 2004-07-19T22:05:54Z |
Is there a way to do a case insensitive select statement.
Where
Select * from table where name = 'john'
would match 'john' 'John' 'JOHN' etc.
Where
Select * from table where name = 'john'
would match 'john' 'John' 'JOHN' etc.