Get Character Count From Text Field

Posted on By David Kittell 
SELECT DATALENGTH(yourtextfield) AS TEXTFieldSize

SELECT MAX(DATALENGTH(yourtextfield)) AS TEXTFieldSize
Originally Posted on April 9, 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

Related Posts

UNIX – Terminal – Oh My Zsh Setup

Posted on

# If on something other than Mac you may need to do ‘apt install git zsh’ or the equivalent sh -c "$(curl -fsSL https://raw.github.com/robbyrussell/oh-my-zsh/master/tools/install.sh)" cat .zshrc | grep ZSH_THEME sed -i ‘.original’ ‘s/ZSH_THEME="robbyrussell"/ZSH_THEME="avit"/gp’ ~/.zshrc cat .zshrc | grep ZSH_THEME As much as I like Oh My Zsh sometimes you have…

Read More

Acrylic Proxy DNS Setup

Posted on

While still configuring my changes to Raspberry Pi Setup Proxy Server this works on an individual computer. NOTE: I have this setup mainly for the Wi-Fi, if you want it for wired connections you will need to change Wi-Fi to “Ethernet” or “Ethernet 2” Step 1: Download and Setup Acrylic…

Read More