Answers for "sql first 10 characters of field"

mysql get first x characters

SELECT LEFT(title , 10) FROM articles;

Posted by: Guest on May-01-2020

reading from right to left from string find first special characters in sql

DECLARE @strvalue varchar(20) = 'SDADH/SDKDS/SD/UIO-123/WEA/456'
SELECT REVERSE(SUBSTRING(REVERSE(@strvalue),0,CHARINDEX ('/',REVERSE(@strvalue))))

Posted by: Guest on November-15-2020

Code answers related to "sql first 10 characters of field"