I need to convert a field from Nvarchar to Float in a search, and get the highest value.
This function works
SELECT MAX(valor)
from [Enops].[dbo].[Tbl_Pulsomedia15_Vazao_Eta_B_Bentes]
Where valor <> 'processando' and valor <> 'Perda de Sinal'.
But when I put the max, it says that it is not a function of the sql server
SELECT Max (cast(valor as nvarchar(200))AS FloatValue)
from[Enops].[dbo].[Tbl_Pulsomedia15_Vazao_Eta_B_Bentes]
Would you have any way to do this?