If you declare parameter varbinary(8000) than you can check what is the lenghth of the value passed in.
>I pass a binary parameter to a SP something like this:
>
>@Data binary(254)
>
>
>I have noticed that if I from my application pass a byte array with more bytes (more than 254 bytes) an exception is
not raised (as I would expect.
>Is there a function I can use to check the number of bytes in a passed binary parameter?
--sb--