Convert Image Columns to Binary Types

You can use the convert function to convert an image column to binary or varbinary.

You are limited to the maximum length of the binary datatypes, which is determined by the maximum column size for your server’s logical page size. If you do not specify the length, the converted value has a default length of 30 characters.