Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

to_number

Status
Not open for further replies.
anniez

anniez

IS-IT--Management
Apr 13, 2001
43
0
0
US
A field (Unit - vchar2(6)) gets updated automatically.
If the value is over 100, the program has to 'do something'
The field could be alpha or numeric.
YOR
ACE
30
30
YOR
190
YOR

Select * from File where to_number(unit) > 100
I'd want it to return the 190 record but it returns nothing. Is there another function that would be better for this?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top