Use translate(nMonth,'@L 99')+'/'+translate(nYear,'9999') and you'll have the wanted size...
Rob Lew wrote: I have a table with 2 numeric cols, one for month, the other for year. If I go to the top of the table where the month is 1 and create a cursor of with a character column formatted mm/yyyy's with the statement select alltrim(str(nMonth))+"/"+alltrim(str(nYear)) .... I get a column that's 21 characters wide -- the width of the 2 underlying numeric columns, plus 1 for the / I thought I would get a col 6 character wide .... Ie len(alltrim(str(nMonth))+"/"+alltrim(str(nYear))) so what is it that I don't understand about trim() functions and column types and widths? ...seems I should know this; don't all shout at once -Lew _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
