How to get the first character of a string in SQL Server ?

Published on September 15, 2016 by abundantcode

Filed under SQL Server

Last modified September 15, 2016

Print this page

rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 3.5 (2 votes)

This article have been viewed 3024 times

Assume a scenario where you have a column in your table in SQL Server database where you want to retreive the first character of the column value.

How to get the first character of a string in SQL Server ?

You can use the LEFT function and specify the column name as well as the number of characters from left that you want to retreive.

Use AdventureWorks2014
GO    
SELECT LEFT(Name,1) as FirstCharacter from HumanResources.Department

image

Leave a Comment


x

You might be Interested in these Posts

C Program to find the G.C.D of a number using Recursive function

Problem Write a program in C to find the find the G.C.D of a number using recursion and display the ...

C Program to print a Half Pyramid using *

Problem Write a program in C to print Half pyramid using * as shown. * * * * * * * * * * ...

C Program to display Positive factors of a number

Problem Write a program in C to display all the positive factors of a number enter by the user. Ho...