SQL Server Transact Basic to Expert - Get number of characters using DataLength

Karthikeyan Anbarasan
13y
2.9k
0
0

Blog

This blog shows how to use the DataLength function to get the number of Unicode characters of a string using SQL.

Example:

SELECT DATALENGTH(N'This is a sample lenght to check')

The expected output would be 68

SQL Server Transact Basic to Expert - Get number of characters using DataLength

Up Next

SQL Server Transact Basic to Expert - Get number of busy CPU milliseconds count created in SQL

Ebook Download

View all

Introducing Microsoft SQL Server 2016

Read by 11k people

Download Now!

Learn

View all