Win a copy of Kubernetes in Action this week in the Cloud/Virtualization forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

to_number function question.  RSS feed

 
Ranch Hand
Posts: 70
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have a sql query which converts my varchar to a number. Whenever there is a field which contains non numerical values. the query returns an error. Is there some way to return null if the field contains non-numerical data, and a number if the field contains numerical data?

my query: "select to_number(col_1) from tbl_a"
 
author & internet detective
Marshal
Posts: 37714
579
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Fritz,
To do that in a non-database specific way, you can use a union:


In some databases, like Oracle, you can use a function for the conditional.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!