var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Case insensitive data query
I have in table Person, having column Name, where data is like,
When I am executing the SELECT Query on the name column,
SELECT * FROM PERSON WHERE NAME = 'john';
I am getting result corresponding to small letters john and not JOHN.
How I should create query so that I will get both results.
Do not expect it to perform well.
select * from person where lcase(name) = 'john'
Tags for this Thread