>>>When running the query it says "Type blob is not a defined system type".
>>>When casting to VarBinary(max) it says "Explicit conversion from data type text to varbinary(max) is not allowed."
>>
>>
>>OK, I thought you were selecting from a vfp table
>>
>>try
>>

>>declare @test table
>>
>>  ( field1 text );
>>
>>insert into @test values('1234');
>>
>>select cast(cast(field1 as varchar(max)) as varbinary(max))
>> from @test;
>>

>
>Great, thanks a lot. I almost gave up!

Seems like you have to convert text to varchar before converting to varbinary