>I have a SQL select getting data from a table which includes an integer field. That integer field is part of the result but in the cursor is generating 11 bytes long on a specific occurence of that field and one byte on another. How can I force the SQL select to put 6 bytes in that field even if the value of the first record is 0?
Michel, maybe this piece of code contains the path to the solution:
select
000000 as field1, ;
a.* ;
from tableX a
You have to format the input.
Groet,
Peter de Valença
Constructive frustration is the breeding ground of genius.
If there’s no willingness to moderate for the sake of good debate, then I have no willingness to debate at all.
Let's develop superb standards that will end the holy wars.
"There are three types of people: Alphas and Betas", said the beta decisively.
If you find this message rude or offensive or stupid, please take a step away from the keyboard and try to think calmly about an eventual a possible alternative explanation of my message.