Search
 
SCRIPT & CODE EXAMPLE
 

SQL

uppercase and lowercase in sql

select UPPER('converted to upper');
select LOWER('CONVERTED TO LOWER');
Comment

how to write uppercase in sql

SELECT UPPER(FIRST_NAME) , LOWER(LAST_NAME)
FROM CUSTOMERS ;
Comment

funktion LOWER/UPPER sql

LOWER/UPPER
LOWER wandelt eine String in eine in Kleinbuchstaben um. 
UPPER ist das Gegenstück zu LOWER, und wandelt den String 
in Grossbuchstaben um.

SELECT LOWER (expression)

SELECT UPPER (expression)
Comment

PREVIOUS NEXT
Code Example
Sql :: postgresql exploit 
Sql :: ORA-01400 
Sql :: list foreign user mapping postgres 
Sql :: postgres sum substract stackoverflow 
Sql :: get employees if not contains in sql 
Sql :: sql column as header 
Sql :: concat string is null postgresql 
Sql :: multiple select into sql oracle 
Sql :: mysql primary vs unique 
Sql :: oracle optional field procedure 
Sql :: get many value to 1 column sql 
Sql :: salesforce cpq apply immediately 
Sql :: how to change the field size of an existing column 
Sql :: insert thai language sql server 
Sql :: There are multiple records in a table and some are duplicates. Which command will fetch only one copy of the duplicate records? Pick ONE option SELECT DISTINCT SELECT UNIQUE SELECT DIFFERENT All of the above 
Sql :: count in spqarql 
Sql :: select from 3 tables one is empty 
Sql :: oracle index hint multiple tables example 
Sql :: oracle parse string 
Sql :: mysql select count if contains 
Sql :: mysql order by calculated column 
Sql :: sql split comma separated string into rows 
Sql :: How to Remove milliseconds from Date time 
Sql :: multiple tricky query in sql server 
Csharp :: ms crm set state request dynamics 365 set state request 
Csharp :: unity how to convert mouse screen position to world position 
Csharp :: how to get last child of gameobject in unity 
Csharp :: unity get layer of gameobject 
Csharp :: how to unlock cursor in unity 
Csharp :: get unix time in seconds C# 
ADD CONTENT
Topic
Content
Source link
Name
6+2 =