|
View previous topic :: View next topic
|
| Author |
Message |
Occitiger
New User
Joined: 12 Jan 2007
Posts: 2
Location: Sacramento
|
|
|
|
I've been looking around trying to find a way to display results from a SPUFI WITHOUT zero suppression.
In specific I have a 13 digit field that when selected will drop off the preceding zeroes (if any)...
Does anyone know how to do such a thing?
I've been looking around, but I'm starting to think that looking for zero suppression is the wrong question, so even if you have an idea on what the right question would be, that would be helpful as well. |
|
| Back to top |
|
 |
Craq Giegerich
Senior Member
Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA
|
|
|
|
| It has nothing to do with sql, it is just the way spufi displays numeric values. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello and welcome to the forum,
Try:
char(the_numeric_col) instead of only the_numeric_col. . . |
|
| Back to top |
|
|
Occitiger
New User
Joined: 12 Jan 2007
Posts: 2
Location: Sacramento
|
|
|
|
Well still haven't figured it out, but am looking into the spufi stuff. Thanks for that hint, sometimes I'm just asking the wrong question.
I figured out a way around and kinda have to run with that for a minute. Hopefully I can come back to this when work settles down becuase I'd really like to know. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Follow-on. . .
My reply probably should have said:
Try:
select char(the_numeric_col) from the_table. . .
instead of only:
select the_numeric_col from the_table. . . |
|
| Back to top |
|
|
|
|
