The answer is to SELECT (FirstName & LastName)=45 from Employees
The =45 will display the column 45 characters wide. "Phil Nolette \(NCS Group, Inc.\)" <[EMAIL PROTECTED]> wrote: >When I am writing to an output file and during a declared cursor, is there a >way to specify the column and not the row? >It would make the report (file) well laid out because of a couple of >variables not maintaining the full size of the declared text size. > >Thanks, >Phil > >I know about how to declare the the newpage and the line counts but I am >just outputting straight out to a file. >For instance: >================================ >DECLARE c1 SCROLL CURSOR FOR + >SELECT resource_id,nm_comp_id+cost_ctr_cd, (last_nm+', '+first_nm), + >(voice_area_cd_nbr+voice_prefix_nbr+voice_suffix_nbr),emp_cd,(VOICE_INT_PREF >IX+voice_suffix_nbr) FROM cd_pn + >WHERE nm_comp_id in (select nm_comp_id from nm_conv where READY = 'Y') + >AND (voice_area_cd_nbr+voice_prefix_nbr+voice_suffix_nbr) IS NOT NULL AND >NCA_USER_ID = 0+ >order by nm_comp_id > >OPEN c1 > >-- Scroll through Corporate Data > >FETCH NEXT FROM c1 INTO vp1, vp2,vp3,vp4,vp5,vint >WHILE SQLCODE <> 100 THEN > > > WRITE ' ' > WRITE 'Corporate Detail Record being Analyzed for Matching NCA - Direct >Dial Number' > WRITE 'CD => ','ID: ',' ',.vp1, 'COMP/CC=> ',.vp2,'DIR-DIAL >=>',.vp4,'NAME = > ',.vp3,'FLAG = >',.vp5, 'Internal = > ',.vint > __________________________________________________________________ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/
