1. Home
  2. SQL

How to get first three letters from a word in sql server

Code examples

2
0

get first 3 letters in sql 

SELECT FIRST_NAME ,  SUBSTR(FIRST_NAME, 1 , 3 ) , LENGTH(FIRST_NAME)
FROM EMPLOYEES ;

Similar pages

Similar pages with examples

sql select first 3 characters of a column
sql string first 5 characters

In other languages

This page is in other languages

Русский
..................................................................................................................
Ссылка
Italiano
..................................................................................................................
Link
Polski
..................................................................................................................
Link
Română
..................................................................................................................
Legătură
한국어
..................................................................................................................
링크
हिन्दी
..................................................................................................................
लिंक
Français
..................................................................................................................
Lien
Türk
..................................................................................................................
Atıf
Česk
..................................................................................................................
Odka
Português
..................................................................................................................
Referênci
ไทย
..................................................................................................................
เชื่อมโยง
中文
..................................................................................................................
链接
Español
..................................................................................................................
Referencia
Slovenský
..................................................................................................................
Odkaz
Балгарскі
..................................................................................................................
Спасылка
Íslensk
..................................................................................................................
Link

Popular in the category

Popular pages with examples in the category

sql select first 3 characters of a column
select first 3 characters in sql
substr in sql server command
função substring sql
t-sql truncate value
how to truncate in sql query
truncate in sql text
sql troncate int value
about truncate in sql
truncate db sql
truncate sqlserver
truncate sql varchar
truncate data in table sql
truncate iun sql
how to truncate decimal value in sql server
truncate the sql table