In article <0f4GwZK00WB78ggVAv_at_andrew.cmu.edu>, "Albert L. Evans, IV" <ae0i+@andrew.cmu.edu> writes:
>
> Is it possible to center a string of text in a field and if so, how? Hopefully
> there is an easy way to do it, rather than having to resort to obscure SQL
> text manipulation functions. Thanks,
>
> Bert Evans
--
The only way I know !
field := LPAD(field,TRUNC((LENGTH(field)+screen_length)/2));
kind regards
Mike
================================================================================
^
Federal Ministry of Science and Research B | M
<-------------------------------------------------------------------------+---->
Computer Center W | F
|
Klaus-Michael Hatzinger mail: hatzinger_m_at_bmwf1f.bmwf.gv.at |
Bankgasse 1/209 phone: 0043-222-53120/5188 |
1014 Vienna, Austria fax: 0043-222-53120/5155 V
================================================================================
Received on Tue Nov 24 1992 - 01:15:02 CST
