Convert string to varbinary

hello,

how can convert text string varbinary?

 

thanks :)

the insert statement works pretty fine; see test script below. sure field in same order in select statement , that's varbinary field?

create table #test

  (field1 int, field2 int, field3 varbinary(100))

go

 

insert into #test    

select 1, 2, convert(varbinary, 'abcdefg')

go

 

drop table #test

 

---

olaf helper ----------- * cogito ergo sum * errare humanum est * quote erat demonstrandum * wenn ich denke, ist das ein fehler und das beweise ich täglich http://olafhelper.over-blog.de

SQL Server  >  Getting started with SQL Server