| Subject | Re: [firebird-support] How to shorten =================================== between header and data rows? |
|---|---|
| Author | Magnus Titho |
| Post date | 2012-06-08T06:24:51Z |
Am 08.06.2012 02:51, schrieb ehaerim:
Anyway, you could use cast to shorten the field. Note however, that the
seperating line is always at least 6 characters long.
select cast(substring(data_feed_name from 1 for 10) as varchar(10)) dfn from test;
--
Magnus
> SQL> select substring(data_feed_name from 1 for 10) dfn from test;[...]
>
> I want the ============================= to be shortened to 15 so that it looks likeStrange request.
>
> DFN
> ===============
> InvestWare
Anyway, you could use cast to shorten the field. Note however, that the
seperating line is always at least 6 characters long.
select cast(substring(data_feed_name from 1 for 10) as varchar(10)) dfn from test;
--
Magnus