SQL- Ignore case while searching for a string

Question

I have the following data in a Table PriceOrderShipped PriceOrderShippedInbound PriceOrderShippedOutbound In SQL I need to write a query which searches for a string in a table  While searching for  a string it should ignore case  For the below mentioned SQL query  SELECT DISTINCT COL NAME FROM myTable WHERE COL NAME LIKE   PriceOrder      gives all the above data  whereas  SELECT DISTINCT COL NAME FROM myTable WHERE COL NAME LIKE   Priceorder      doesn t give   Eg  when I search for  PriceOrder  or  priceOrder  it works but  priceorder  or  Priceorder  doesn t work  I have tried with the below query using COLLATE  but its not working  Do let me know where im going wrong   SELECT DISTINCT COL NAME FROM myTable WHERE  COL NAME COLLATE latin1 general cs LIKE   Priceorder

User · Accepted Answer

Use something like this -   SELECT DISTINCT COL NAME FROM myTable WHERE UPPER COL NAME  LIKE UPPER   PriceOrder      or   SELECT DISTINCT COL NAME FROM myTable WHERE LOWER COL NAME  LIKE LOWER   PriceOrder

User · Answer

Like this   SELECT DISTINCT COL NAME FROM myTable WHERE COL NAME iLIKE   Priceorder     In postgresql

User · Answer

See this similar question and answer to searching with case insensitivity - SQL server ignore case in a where expression  Try using something like   SELECT DISTINCT COL NAME  FROM myTable  WHERE COL NAME COLLATE SQL Latin1 General CP1 CI AS LIKE   priceorder

User · Answer

You should probably use SQL Latin1 General Cp1 CI AS KI WI as your collation  The one you specify in your question is explictly case sensitive   You can see a list of collations here

[sql] SQL- Ignore case while searching for a string

Examples related to sql

Examples related to sql-server

Examples related to case-insensitive

Examples related to sql-like

Examples related to ignore-case