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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

NULL? please help asap

Status
Not open for further replies.
Stevennn

Stevennn

Programmer
Apr 4, 2007
52
US
I'm trying to pull data thru progress and I need to execute this statment but it's not working..
IFNULL(TO_CHAR(commission_pct), 'NONE'), i tried it with ISNULL also.....


Any ideas what script to use to put in 'NONE' into NULL fields...............

Can't do update because it needs to be done while i'm pulling data into Oracle.


Thank-you for your HELP!!!!1
 
Status
Not open for further replies.

Similar threads

araichura
  • Locked
  • Question
help on openedge
Replies
1
Views
60
tonys123
tonys123
kingly
  • Locked
  • Question
SQL Server 2000 linked Server to Progress 9.1D - help
Replies
2
Views
67
kingly
kingly
paulmarr
  • Locked
  • Question
Help needed Connecting Crystal to Progress db (Cedar Creek)
Replies
2
Views
88
paulmarr
paulmarr
chefsride
  • Locked
  • Question
symix syteline progress error help
Replies
1
Views
79
longhair
longhair
mdemon
  • Locked
  • Question
Help this muppet! Progress tables dead?! Error 7870 Lock Table is full 1
Replies
6
Views
96
mdemon
mdemon

Part and Inventory Search

Sponsor

Back
Top