What is ISNUMERIC in Transact-SQL? It is used to determine that the value is numeric or not. It will return ‘1′ when the value is numeric. Else it will return ‘0′.

Example,

DECLARE @temp nvarchar(100);
SELECT @temp = ‘100′;
SELECT ISNUMERIC(@temp);

The returned result is ‘1′.

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • Digg
  • del.icio.us
  • StumbleUpon
  • Technorati
  • Reddit
  • Facebook
  • Google
  • Live
  • YahooMyWeb
  • Furl
  • Slashdot
  • Spurl
  • Mixx
  • BlinkList
  • Bumpzee

Tags: