Search
 
SCRIPT & CODE EXAMPLE
 

SQL

ignore case in string sql

select * from users where upper(first_name) = 'FRED';
Comment

SQL server ignore case in a where expression

SELECT * FROM myTable WHERE myField = 'sOmeVal' COLLATE SQL_Latin1_General_CP1_CI_AS
Comment

PREVIOUS NEXT
Code Example
Sql :: warning: mysqli::__construct(): (hy000/2002): 
Sql :: mysql query to find duplicate records 
Sql :: table structure in sql 
Sql :: sql drop table 
Sql :: get locked tables sql server 
Sql :: mysql if statement 
Sql :: group by clause with join in sql 
Sql :: select all tables linked server sql 
Sql :: android sqlite database example 
Sql :: read xml in sql server 
Sql :: oracle chain rules 
Sql :: update value sql 
Sql :: insert query mysql workbench 
Sql :: sql unique constraint 
Sql :: mysql fetch all data 
Sql :: truckat table mysql 
Sql :: mysql regexp replace 
Sql :: difference between outer join and inner join sql 
Sql :: remove root password mysql 
Sql :: create unique constraint postgres 
Sql :: delete vs truncate sql server 
Sql :: sql arithmetic operators 
Sql :: cast in sql 
Sql :: SQL Server OPENQUERY WITH result SETS 
Sql :: sql server set default value equal to auto increment 
Sql :: min mysql 
Sql :: mysql count 
Sql :: mysql workbench format date 
Sql :: mysqldump devilbox 
Sql :: round .5 to 1 in sql server 
ADD CONTENT
Topic
Content
Source link
Name
1+6 =