-- =============================================
-- Author: Farzin Monsef
-- Create date: June 16 2016
-- For checking if a value is Integer
-- =============================================
ALTER Function dbo.IsInteger(@Value VarChar(18))
Returns Bit
As
Begin
Return IsNull(
(Select Case When CharIndex('.', @Value) > 0
Then Case When Convert(int, ParseName(@Value, 1)) <> 0
Then 0
Else 1
End
Else 1
End
Where IsNumeric(@Value + 'e0') = 1), 0)
-- ============================================= -- Author: Farzin Monsef -- Create date: June 16 2016 -- For checking if a value is Integer -- ============================================= ALTER Function dbo.IsInteger(@Value VarChar(18)) Returns Bit As Begin
Return IsNull( (Select Case When CharIndex('.', @Value) > 0 Then Case When Convert(int, ParseName(@Value, 1)) <> 0 Then 0 Else 1 End Else 1 End Where IsNumeric(@Value + 'e0') = 1), 0)
End