|
| |
|
|
Crock
Posts: 13
From: Castle Rock
Status: offline
 |
Values returning 0 - 3/8/2001 14:12:00
My query keeps returning 0 (zero) for NETACRES when I run this SQL statement against an Oracle database. The query is giving the correct information but the value just isn't displaying correctly. I know I must be missing something but I just don't see it. Any help would be great.SELECT ACCOUNTNO, NETACRES
FROM PUB_PARCEL_SEG_LAND
WHERE (NETACRES > '::NETACRES::')
|
|
|
|
Elecia
Posts: 68
From: orlando
Status: offline
|
RE: Values returning 0 - 3/8/2001 15:27:00
Oracle loves to pad fields. Maybe try using a trim statement to get rid of those extra spaces. Padding has been a great source of aggravation for me and many wasted hours. It's only a thought.
EE
| |
|
|
|
Crock
Posts: 13
From: Castle Rock
Status: offline
|
RE: Values returning 0 - 3/8/2001 16:19:00
The trim command worked!!!
You are the best.Thanks!!!
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
