Search
 
SCRIPT & CODE EXAMPLE
 

SQL

substr sql last character

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

sql server last character in string

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

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 
ADD CONTENT
Topic
Content
Source link
Name
4+3 =