Vince:
I think you meant to suggest I look at len(alltrim(str(1))), no?
Any weekend is a *great* idea.
-Lew
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Vince Teachout
Sent: Friday, July 14, 2006 5:20 PM
To: [EMAIL PROTECTED]
Subject: Re: Alltrim(str(<numeric>)) works, but why?
Lew Schwartz 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 onc
>
Nothing wrong with the trims. Here's a hint:
? Str(1)
? Len(Str(1))
:-) Enjoy the weekend!
[excessive quoting removed by server]
_______________________________________________
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.
