found a function that will do the conversion. from M$'s knowledge base: http://support.microsoft.com/kb/886839
CREATE FUNCTION dbo.fn_convertnumericlsntobinary(
@numericlsn numeric(25,0)
) returns binary(10)
AS
BEGIN
-- Declare components to be one step larger than the...