Previous Article ASP Classic and SQL Server - Check if Email exist if not insert else show message |
SQL Server How to get the number of Characters from a string in a column |
Next Article SQL Server Management Studio - Restore database |
Coding Article #: 1084 - Published On: February 13, 2021 @ 03:34:20 AM - Last Updated on: February 15, 2021
This article has been Favorited 0 timesJoin today, and add this to your favorites.
Share With Friends (Updated 6-8-2010)
Supported Files
No Files for this Article.
No Files for this Article.
No Screenshot Available
In this lesson, we are going to get the number of characters from a database column.
Open SQL Server Management Studio.
Right-Click on the database.
Choose [New Query]
Paste the below code and click [Execute]
Open SQL Server Management Studio.
Right-Click on the database.
Choose [New Query]
Paste the below code and click [Execute]
select LEN(ColumnName) from evContent
--With a Querystring added.
select LEN(ColumnName) from Content where ID=1
Post to Facebook about: SQL Server How to get the number of Characters from a string in a column