Useful data type validation functions
It would be nice to include more useful data type validation functions in SQL server. For example ISNUMERIC returns 1 when the input expression evaluates to a valid integer, floating point number, money or decimal type. Using ISNUMERIC to test character data before inserting into an integer column can be very problematic when the character data is valid for a money data type but not an integer data type. I am sure many developers have struggled with validating numeric data because of this.
Upvotes: 1<=-=Aug 14 2009 3:50PM=-=>
Thanks for the feedback! This is a good suggestion and we will investigate it for future releases of SQL Server.
- Tobias<=-=Mar 24 2011 4:41PM=-=>
Thank you for submitting this suggestion, but given its priority relative to the many other items in our queue, it is unlikely that we will actually complete it. As such, we are closing this suggestion as �won�t fix�. If you feel that this is worth reconsidering, feel free to respond to this message and we will take another look.
SQL Server Engine