Sql

SELECT length('abcd') FROM DUAL;		-- Oracle
SELECT length('abcd');					-- MySql / PostGreSQL
SELECT len('abcd');						-- SQL Server

SELECT CHAR_LENGTH(column_name) AS 'alias' FROM table;

#example
select title, CHAR_LENGTH(title) as  'char_count' from books;

-- Relevant for MS SQL (SQL Server)
LEN('string')

PREVIOUS	NEXT

Code Example
Sql :: FIND ABOVE AVERAGE SALARY EARNER IN SQL
Sql :: mysql delet from the child table when we delete the rows from the parent
Sql :: sqlalchemy default value for column
Sql :: sql select inside select sub query
Sql :: sql max count
Sql :: mysql workbench change default value
Sql :: soql- select all fields
Sql :: mysql copy row with new id
Sql :: sql constraint to check date less than current date
Sql :: MySql query execution order:
Sql :: postgres advance table id count
Sql :: violation of primary key constraint
Sql :: sql: extract day text from datetime value
Sql :: postgresql create user roles
Sql :: sql server get number of working days in a month
Sql :: database passwords from dbeaver
Sql :: to_sql pandas
Sql :: Write an SQL query to determine the 5th highest salary without using TOP or limit method.
Sql :: sql case sttement with set
Sql :: sql is null or empty
Sql :: SQL JOIN and Aliases
Sql :: CREATE table schema using select
Sql :: sqlite select regex
Sql :: new rails app with mysql
Sql :: postgres isnull
Sql :: mariadb
Sql :: break too long line yaml
Sql :: Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema?
Sql :: mysql group by derived column
Sql :: alter domain sql