And if you want to name the field, (in your cursor) select space(6) as my_field Will return to you a field named my_field.. with 5 spaces in it. . Bob Lee
----- Original Message ----- From: "Kevin Cully" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, May 24, 2007 10:20 AM Subject: Re: [NF] MySQL equivalent for SPACE(nn)? > SELECT SPACE(6); > > > -Kevin > CULLY Technologies, LLC > > Sponsor of FoxForward 2007 > foxforward.net > > > MB Software Solutions wrote: >> I'm creating a UNIONed SQL where I know the first SQL will just be >> blanks for a certain field, and the 2nd SQL will pulled from a table to >> get the real/actual value. Is there an equivalent in MySQL to the >> SPACE(nn) command in VFP? >> > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** 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.
