How to determine length of text field in Microsoft SQL Server

Don't answer. I already have a winning bid but rentacoder is unable to process credit cards so I can't close out. Thanks I need an sql statement to to determine the length of Microsoft SQL Server text field. Len is not usable on text field. What is another way to get at this information? ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site). ## Platform Microsoft SQL Server