Advertiser Disclosure

Download our iPhone app

TODAY'S HEADLINES | ARTICLE ARCHIVE | FORUMS | TIP BANK

Specialized Dev Zones

Research Center

eBook Library

.NET

Java

C++

Web Dev

Architecture

Database

Security

Open Source

Enterprise

Mobile

Special Reports

10-Minute Solutions

DevXtra Blogs

Slideshow

Specifying an Oracle Hint at INSERT

SQL Server - INSERT and ignore on duplicate key

SQLServer - insert IDENTITY

Tip: How to Convert char to int

Tip: Converting a Java List to an array

Tip: Using the DATALENGTH SQL Function

Learn how to use a SQL function to return the length of a column in a table.

by Hannes Du Preez

Feb 13, 2019

The DATALENGTH SQL returns the length of columns in a table.

SELECT length = DATALENGTH(ColumnName) 
FROM TableName 
ORDER BY ColumnName

Visit the DevX Tip Bank

Thanks for your registration, follow us on our social networks to keep up-to-date