Error

select * from Discount

select MAX(DiscountID) from DiscountTest

select MAX(Convert(int, substring(DiscountID, 4, 20))) as thismaxid from DiscountTest

select MAX(Convert(float,REPLACE(substring(DiscountID,4, 20),'V',''))) as thismaxid from Discount

select GETDATE()

select DAY('2012-01-02')  YYYY-MM-DD  select DAY('01-02-2012')  MM-DD-YYYY

SELECT SUBSTRING(CONVERT(varchar,MAX(Convert(float,REPLACE(substring(DiscountID,4, 20),'V','')))),
(CHARINDEX('.', CONVERT(varchar,MAX(Convert(float,REPLACE(substring(DiscountID,4, 20),'V','')))))+1),
LEN(CONVERT(varchar,MAX(Convert(float,REPLACE(substring(DiscountID,4, 20),'V','')))))) as thismaxid from discount

DECLARE @d DATETIME = GETDATE();  SELECT FORMAT(GETDATE())
SELECT MAX(Convert(float,REPLACE(substring( DiscountID,4, 20),'V',''))) as thismaxid from discount

select ( SELECT SUBSTRING(CONVERT(varchar,MAX(Convert(float,REPLACE(substring(DiscountID,4, 20),'V','')))),
(CHARINDEX('.', CONVERT(varchar,MAX(Convert(float,REPLACE(substring(DiscountID,4, 20),'V','')))))+1)
, LEN(CONVERT(varchar,MAX(Convert(float,REPLACE(substring(DiscountID,4, 20),'V','')))))) as thismaxid from discount) as themaxid1,
( select MAX(Convert(float,REPLACE(substring(DiscountID,4, 20),'V',''))) as thismaxid from Discount ) as themaxid2

select
( select MAX(Convert(float,REPLACE(substring(DiscountID,4, 20),'V',''))) as thismaxid from Discount ) as themaxid2,
(SELECT SUBSTRING(CONVERT(varchar,MAX(Convert(float,REPLACE(substring(DiscountID,4, 20),'V','')))),
(CHARINDEX('.', CONVERT(varchar,MAX(Convert(float,REPLACE(substring(DiscountID,4, 20),'V','')))))+1)
, LEN(CONVERT(varchar,MAX(Convert(float,REPLACE(substring(DiscountID,4, 20),'V','')))))) as thismaxid from discount) as themaxid1


select
( select MAX(CONVERT(FLOAT,Replace(SUBSTRING(DiscountID,5, 6), 'V',''))) as thismaxid from Discount ) as themaxid1,
(SELECT SUBSTRING(CONVERT(varchar,MAX(Convert(float,REPLACE(substring(DiscountID,4, 20),'V','')))),
(CHARINDEX('.', CONVERT(varchar,MAX(Convert(float,REPLACE(substring(DiscountID,4, 20),'V','')))))+1)
, LEN(CONVERT(varchar,MAX(Convert(float,REPLACE(substring(DiscountID,4, 20),'V','')))))) as thismaxid from discount) as themaxid2