Posted by Greg Low [MVP] on 10/01/62 11:38

In addition to what ZeldorBlat said, if you need to make larger values, keep
in mind that the + operator is used to concatenate binary strings.

eg: 0xA34B + 0xCA02 is 0xA34BCA02

This can help break such strings up over multiple lines in a script.

HTH,

Greg

"Water Cooler v2" <wtr_clr@yahoo.com> wrote in message
news:1138493601.782824.249580@o13g2000cwo.googlegroups.com...
> There are two datatypes for storing binary data type in the SQL Server:
>
> 1. binary - for fixed length binary data
> 2. varbinary - for variable length data
>
> My question is: how is data inserted into them? Do they have any
> delimiters that go into the insert statement like strings and datetimes
> have? What format (hex/decimal?) do they accept data in? Can you please
> give me an insert statement example?
>

[Back to original message]