Converting Long Character String Into Short String

Converting Long Character String Into Short String

How can do I write a query to retrieve a string with a specific number of characters from a field? For example, the “firstname” field has a name that is 25 characters long and I want to retrieve only the first 10 characters.

Use the LEFT function to return the leftmost 10 characters from a column (I assume the column is character datatype). If leading spaces are a possibility, combine this function with LTRIM like this:

SELECT ID, LEFT(LTRIM(FirstName) AS FirstName,10)FROM Contacts

You could also use SUBSTRING, but it takes a starting position as well as the number of characters to return. So LEFT is a little simpler.


About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist