How to get FIRST CHARACTER of STRING in SQL

Опубликовано: 10 Октябрь 2024
на канале: Learn SQL
9,355
34

This video is about how to get FIRST CHARACTER of STRING in SQL.

Script:
SELECT id
,LEFT(first_name,1) as first_character
,last_name
,email
,telephone
,height
FROM dbo.persons

Keywords:
how to get FIRST CHARACTER of STRING in SQL, sql first character, first character sql, first character in sql, sql get first character, sql first character of string, sql first characters of string, sql only first character, sql get only first character, sql return only first character, sql select only first characters,
select first character sql, select first character in sql, select first characters sql, select first letter sql, sql server, learn sql, sql