BT的BINARY转换问题

Question

try：
select substring(cast(@Options as varchar(8000)),48,1)

Answer 1

example:
-------------------------------------------------------------------
declare @Options varbinary(4000)set @Options=0x1212323123123123123Aselect substring(cast(@Options as varchar(8000)),5,1)/*
---- 
#
*/

Answer 2

Select 
CAST(SUBSTRING(CLEI.Options,6,1) AS INT)%2 AS FLAG,CLEI.Options
from 
CWORKORDER cw inner join CustomerLEI CLEI on Cw.BillToCustomerCode=CLEI.Code