SELECT *, x.lib_no_num FROM books b
CROSS APPLY (
SELECT TRY_CAST(LTRIM(RTRIM(b.lib_no)) AS decimal(18,6)) AS lib_no_num
) x
WHERE (Enabled = 1) AND (IsHide = 0) AND item_no NOT LIKE 'Z%' AND PLANNING_MAKE_BUY_CODE='Make'
AND Item_Status in ('Active','NActive','代銷書') AND USER_ITEM_TYPE in ('0套書','1單本書','8文創(自製)商品類')
AND x.lib_no_num >= 800 AND x.lib_no_num < 900 ORDER BY PublishDate desc
遠流博識網
