Binary data with scripts...

[Chinners]

Hi, I dont know if this is possible, but I'll ask anyway. I need to be able to send an SQL script as a text file, or something similar. The script will be modifying a few columns, and inserting a few new rows. Nothing too complictated.... However... I am using SqlCE 3.5, so the commandset is slightly reduced, and, worst of all, one of the fields is an Image (i.e. Binary). Its not huge, most records are about 1k, however, it has thrown a bit of a spanner in the works for my simple script idea. So, I guess I am asking, is there a reasonably simple way to script a database which contains binary data? Thanks, Jason

[Chinners]

Replying to my own question... I must be sad :o) Anyway, it was easy... after a lot of googling:

insert into [Table] (Field) Values (0x1232132132)

I am a bit ashamed that I missed that. Posted here in case someone else needed it.