FUNCTION fIsNumbers

Check that the substring is a valid number.

fIsNumbers(string, start, stop) Returns
-1: REAL (contains decimal point) ([+|-]digits.digits)
0: not a number
1: BIGINT ([+|-] 19 digits)
select dbo.fIsNumbers('123;',1,3); select dbo.fIsNumbers('10.11;'1,5);

Input and output parameters

name type length inout pnum

int 4 input 0

@start int 4 input 2

@stop int 4 input 3

@string varchar 8000 input 1

name	type	length	inout	pnum
	int	4	input	0
@start	int	4	input	2
@stop	int	4	input	3
@string	varchar	8000	input	1