Try: SELECT DATALENGTH(columnname) as collen, FROM ..........
-Cameron ----------------- Cameron Childress Sumo Consulting Inc. http://www.sumoc.com --- cell: 678.637.5072 aim: cameroncf email: [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Brent Helms Sent: Monday, September 19, 2005 2:14 PM To: [email protected] Subject: SQL Server Question - Data Type: Image (size?) Does anyone know if there is a way, via TSQL, to determine the actual size of a column with a data type of "image"? I know what it can max out at, but determining the actual size on the individual column for each row is what I'm trying to achieve. Best Regards, Brent Helms ---------------------------------------------------------- To post, send email to [email protected] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
