how to check if value is numeric in sql server
  • how can i check that column is numeric or not in sql server?
  • 1 Comment sorted by
  • you can use IsNumeric function in sql server 2008.

    if this function return 1 so its mean value is numeric.
    if this function return 0 so its mean value is non numeric.

    select ISNUMERIC(ColumnName) from TableName

Howdy, Stranger!

It looks like you're new here. If you want to get involved, or you want to Ask a new Question, Please Login or Create a new Account by Clicking below

Login with Facebook

Tagged

Popular Posts of the Week

Top Posters Weekly

Optimum Creative