ZeroBlob SQL Function

The ZeroBlob() function takes one (1) argument as integer and returns a BLOB value consisting of first parameter size bytes. All of the bytes are set to the value zero. The maximum value of first argument is 1000000000 passed as integer and the number is exactly one billion. Depending on Computer System it can take few seconds to create billion byte blob. A negative value passed will return Null.

Syntax ZeroBlob( Integer Blob Size )

/* Following will return four bytes empty blob known as bytes array in .Net */
SELECT ZeroBlob(4);