Image Length

Posted on 2005-05-16
Last Modified: 2010-03-19
Is there a quick and inexpensive way to get the length of an image column?
I need to have the byte count to get an accurate idea of download times.
so something like len(imagecol) which only works for strings.

Thanks in Advance
Question by:painlessprod
    LVL 7

    Accepted Solution

    Use the Datalength() function

    Select DATALENGTH(imagecol) FROM Table1 where recid = ????


    Author Comment

    that was quick, thanks
    LVL 7

    Expert Comment

    just happen to be passin' thru...  :)

    Glad I could be of help.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    I recently came across an interesting Question In EE ( and was puzzled about how to achieve that using SSIS out of the box tasks, which was i…
    I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    732 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

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now