Sql

SELECT RIGHT( '1234567890', 4 ); -- returns '7890'
SELECT SUBSTR( _col_NAME_, LENGTH(_col_NAME_)-3, 4 ); -- string indexing starts from 1

SELECT RIGHT('SQL Tutorial', 1) AS ExtractString;

PREVIOUS	NEXT

Code Example
Sql :: sort by mysql
Sql :: set value to null sql
Sql :: sql cast
Sql :: SQL query to verify the size of the table
Sql :: SQL Less Than or Equal to Operator
Sql :: get clob size oracle
Sql :: postgresql grant owner to user
Sql :: create scalar function in sql server
Sql :: enable full text search mysql
Sql :: data formate in sql
Sql :: postgresql parse json array
Sql :: export mysql db using command line
Sql :: setting default value for Boolean data type in SQL
Sql :: rename column name sql server
Sql :: check if value is null mysql
Sql :: open postgresql.conf
Sql :: get sum sqlite android
Sql :: mysql create table query
Sql :: postgres recursive function
Sql :: sql pass table name as variable
Sql :: postgresql must appear in the GROUP BY clause or be used in an aggregate function
Sql :: SQL Copy to Another Database
Sql :: postgresql in array
Sql :: coalesce sql
Sql :: sql select from multiple tables without join
Sql :: if null put 0 sql
Sql :: sql select all records from all tables where not empty
Sql :: between
Sql :: mysql best tutorial for beginners
Sql :: How to search for a String in all Columns in all tables in SQL Server Database