For MySQL following will work: SELECT name FROM mytable WHERE LOWER(name) = 'ganesh' -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.qt-project.org/pipermail/qt-interest-old/attachments/20100210/c666dfd2/attachment.html