Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

character count of text datatype

Posted on 2010-08-12
3
Medium Priority
?
614 Views
Last Modified: 2012-05-10



column1 is text datatype

how do i find character count
0
Comment
Question by:rgb192
3 Comments
 
LVL 23

Accepted Solution

by:
Kamaraj Subramanian earned 1000 total points
ID: 33422569

SELECT DATALENGTH(yourtextfield) AS TEXTFieldSize

Open in new window

0
 
LVL 1

Assisted Solution

by:ronythom
ronythom earned 1000 total points
ID: 33423034
select length(textfield)as length_of_text from table
0
 

Author Closing Comment

by:rgb192
ID: 33423785
thanks
0

Featured Post

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…

885 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question