Can you explain what exactly is strange about result? How do you display it? Are none-prportional fonts involved?
What
SELECT LEN(ALLTRIM(BlockDetails)) FROM ResultCursor
returns for each row?
>Hi all, when I run the query shown below I get a strange result set ( I expect the rows to be all 50 chars long )
>
>
>Select PADR(allt(Mytable.blkd_desc),50,'*');
>As BlockDetails;
>From Multiblk;
>Inner Join Blockpay;
>On Multiblk.block = BlockPay.block
>
>
>The results I get are similar to the ones shown below
>
>
>My first record***********************************
>Second***************************************
>Third********************************************
>And so on*********************************
>
>anyone know what gives here ?
--sb--