Answers for "sql get first character of string"

sql server substring

SELECT SUBSTRING('SQL Tutorial', 1, 3) AS ExtractString;

Posted by: Guest on May-18-2020

sql first character

Select First two Character in selected Field with Left(string,Number of Char in int)

SELECT LEFT(FName, 2) AS FirstName FROM dbo.NameMaster

Posted by: Guest on March-02-2021

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 get first character of string"