Max Length Of Data In Column

Posted on By David Kittell

Get Max Length Of Column

SELECT max(length(<col>))
FROM <TABLE>;

SELECT max(len(<col>))
FROM <TABLE>;
Originally Posted on November 1, 2013
Last Updated on October 26, 2015
All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.
Code MSSQL Oracle SQL

Related Posts

UNIX – Display Network Information

Posted on

The following code will give you network specific information about your server/computer. All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing…

Read More

Ektron – Widget Form

Posted on

In the recent upgrade from Ektron 8.0.2 to 8.7 I’ve been rebuilding forms to user controls that can be used as widgets. Below is basic elements to make the form work for your Ektron 8.7 (possibly higher). Please note the TextBox SubmissionEmail, this allows you to change the email address…

Read More

UNIX – SED Replace Tab with Space(s)

Posted on

sed ‘s/\t/ /g’ tab-file.txt > no-tab-file.txt Originally found at https://linuxconfig.org/replace-all-tab-characters-with-spaces All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just…

Read More