You can use CAST to convert Char/Varchar TO Numbers

DECLARE @MyCharExpression AS VARCHAR(50)

SET @MyCharExpression = 'Invalid Noumber'
SELECT CASE WHEN ISNUMERIC(@MyCharExpression) = 1 THEN CAST(@MyCharExpression AS INT) ELSE 0 END
	
SET @MyCharExpression = '25'	
SELECT CASE WHEN ISNUMERIC(@MyCharExpression) = 1 THEN CAST(@MyCharExpression AS INT) ELSE 0 END

SET @MyCharExpression = '25.002'	
SELECT CASE WHEN ISNUMERIC(@MyCharExpression) = 1 THEN CAST(@MyCharExpression AS MONEY) ELSE 0 END
GO

>Hi,
>
>What is the function on sql can be used instead of val() on vfp.
>
>
>Best Regards