SELECT CAST('2d3' AS float)

DECLARE @profile CHAR(10)

IF PATINDEX('%[^0-9]%', '£123432345') = 0 
    SET @profile = 'NUMBER'

ELSE 
    SET @profile = 'CHAR'


SELECT  @profile

CREATE FUNCTION IsNumeric2(@str varchar(20))
RETURNS int
  WITH SCHEMABINDING
AS
BEGIN
declare @results int
SELECT @results = CASE 
                WHEN (PATINDEX('%[^0-9,.]%', @str) = 0) AND (LEN(@str) - LEN(REPLACE(@str,'.','')) <= 1)
                THEN 1
                ELSE 0
              END
  return @results
END --FUNCTION
      GO
CREATE FUNCTION IsNumeric3(@str varchar(20))
RETURNS TABLE
  WITH SCHEMABINDING
AS
RETURN(SELECT CASE 
                WHEN (PATINDEX('%[^0-9,.]%', @str) = 0) AND (LEN(@str) - LEN(REPLACE(@str,'.','')) <= 1)
                THEN 1
                ELSE 0
              END As boolNumeric
      ) --END FUNCTION