Previous Topic

Next Topic

Inhoudsopgave

Book Index

Implicit Conversion From A String Type To (var)binary

Both ASE and MS SQL Server can implicitly convert a (var)binary to a string, but ASE can also implicitly convert a string to a (var)binary, whereas this is impossible on MS SQL Server.

Example

declare @c varchar(20), @b varbinary(20)

set @c = 0x1234abcf

set @b = @c

select @b