Re: Oracle Reports 3.0.5 - leading spaces problem
From: John Mac Isaac <John_Mac_Isaac_at_standardaero.ca>
Date: 9 Nov 1998 19:08:05 GMT
Message-ID: <01be0c14$81ee2620$7d641f81_at_4021.standardaero.ca>
Date: 9 Nov 1998 19:08:05 GMT
Message-ID: <01be0c14$81ee2620$7d641f81_at_4021.standardaero.ca>
try to use ltrim
eg.LTRIM(FIELDNAME)
it sould remove the leadind spaces then just order by the fieldname
hope this helps
catcher25_at_my-dejanews.com wrote in article
<7274le$d44$1_at_nnrp1.dejanews.com>...
> We are trying to print a field that has some records with 9 leading
spaces.
> We are ordering by the 10th position and this works fine but it is
ignoring
> some of the leading spacees when printing and the records are not lining
up
> properly. Can anyone help us remedy this situtaion?
>
> Thanks.
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
Received on Mon Nov 09 1998 - 20:08:05 CET