Sql Case Senstiveness Remove in query...

SELECT FIRSTNAME FROM table1
WHERE FIRSTNAME
COLLATE SQL_Latin1_General_CP1_CI_AS like '% KIRAN%'


This will show all records where First name have Kiran, KIRAN, kiran...

if Suppose You Sql Database is Case Sensetive.. then only....


I have check in Ms Sql....


Thank you...