Am 08.06.2012 02:51, schrieb ehaerim: > 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 like > > DFN > =============== > InvestWare
Strange request. 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