BT的BINARY转换问题

[Mike老羊]

我现在遇到一个SQL的问题,我们客户要在存储过程中取一个binary类型的字段的48位的一个值并转换为VARCHAR(1)请问能实现吗?怎么实现.
如:
Declare @Options binary(100)
Select
@Options=CLEI.Options
from
CWORKORDER cw inner join CustomerLEI CLEI on Cw.BillToCustomerCode=CLEI.Code
Where
CW.workorder='BT345896'
要去@Optins的地48为的值(这里暂时把@Options当字符串)
谢谢了

[子陌红尘]

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

[子陌红尘]

example:
-------------------------------------------------------------------
declare @Options varbinary(4000)

set @Options=0x1212323123123123123A

select substring(cast(@Options as varchar(8000)),5,1)

/*
----
#
*/

[fdlm_dark]

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