If you want to find Non-Integer from Column in SQL Server that does not have Data Type integer , Use following SQL Query.
Select * From [ChildRegistration]
Where IsNumeric(ChildID + '.0e0') = 0
If you want to find Integer from Column in SQL Server that does not have Data Type integer , Use following SQL Query.
Select * From [ChildRegistration]
Where IsNumeric(ChildID + '.0e0') = 1
