If you  are doing one record at a time, you can copy and paste the text into Word and see the Word count at the bottom of the screen. (If you do not see the word count, right-click the status bar at the bottom and check Word Count.)

If you want to get a word count for many records, you could try this function taken from the web:
T-SQL function to get word count<http://www.websolete.com/posts/t-sql-function-to-get-word-count>
Posted by Kevin J. Miller in SQL Server<http://www.websolete.com/archives/category/sql-server> on November 18, 2008
Similar in approach to the previous uf_charCount function, the following function returns the number of words in a string, assuming a space token as word separator.
CREATE FUNCTION [dbo].[uf_wordCount] (@string varchar(8000))
RETURNS SMALLINT
/*
        Purpose: returns the number of words in @string
        Author: Kevin J. Miller (www.websolete.com)

        Example:
               SELECT dbo.uf_wordCount('four score and seven years ago')
               would return: 6

*/
AS
BEGIN
        SET @string = LTRIM(RTRIM(ISNULL(@string,'')));
        IF LEN(@string) = 0 RETURN 0;
        -- return the difference in length after stripping spaces, this is the word count
        RETURN ((LEN(@string) + 1) - LEN(REPLACE(@string,' ','')));
END

<http://www.websolete.com/posts/t-sql-function-to-get-word-count#tab-1>

Note, however, that if you are running this function against a text field you will first need to Cast or Convert it to a VARCHAR field not exceeding 8000 characters; if your text fields exceed this length the function will not work.

John Churchman
Office of the Chief Information Officer
Smithsonian Institution
Work: 202-633-0619
Cell:   703-300-6574

From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Ella Rothgangel
Sent: Friday, November 30, 2012 10:50 AM
To: [log in to unmask]
Subject: field word count

Has anyone found a way to count the number of words in a field?  Either a large text field or text entries is fine.  I have curators interested in composing label copy in tms, but I need to have an answer to the word count hurdle.

Thanks,

Ella



Ella Rothgangel
Collections Information & Imaging Administrator
Saint Louis Art Museum
One Fine Arts Drive, Forest Park
St. Louis, Missouri  63110
314.655.5408

To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

     signoff TMSUSERS

     //  eoj


You will receive a confirmation that your subscription has been removed.