Ciao a tutti qui sotto la mia query:

CO_Promotions.DiscountValue = 7.7777

SELECT PromotionTypes.descr,CO_Promotions.Promotionid,CO_ Promotions.Description,CO_Promotions.StartDate,CO_ Promotions.EndDate FROM CO_Promotions INNER JOIN PromotionTypes ON CO_Promotions.PromotionType = PromotionTypes.id where convert(nvarchar,CO_Promotions.DiscountValue,2) like '7%'

e questa funziona cioè mi trova il record


SELECT PromotionTypes.descr,CO_Promotions.Promotionid,CO_ Promotions.Description,CO_Promotions.StartDate,CO_ Promotions.EndDate FROM CO_Promotions INNER JOIN PromotionTypes ON CO_Promotions.PromotionType = PromotionTypes.id where convert(nvarchar,CO_Promotions.DiscountValue,2) like '%7'

questa non funziona xchè