Re: [NF] MySQL equivalent for SPACE(nn)?

2007-05-25 Thread MB Software Solutions
Man-wai Chang wrote: SELECT SPACE(6); Aaah! Nice...it's great that they respected us VFPers enough to make it the same! ;-) Not always. For example, you can't do SELECT f1+f2, you have to use SELECT CONCAT(f1,f2). Well of course not always !! I meant very similar at

Re: [NF] MySQL equivalent for SPACE(nn)?

2007-05-25 Thread Man-wai Chang
Not always. For example, you can't do SELECT f1+f2, you have to use SELECT CONCAT(f1,f2). Well of course not always !! I meant very similar at times. I wished someone with Foxpro background did join the MySQL team back then... :) -- @~@http://changmw.homeip.net / v \ May the

Re: [NF] MySQL equivalent for SPACE(nn)?

2007-05-25 Thread Bob Lee
: [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

[NF] MySQL equivalent for SPACE(nn)?

2007-05-24 Thread MB Software Solutions
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? -- Michael J. Babcock, MCP MB Software Solutions, LLC

Re: [NF] MySQL equivalent for SPACE(nn)?

2007-05-24 Thread Kevin Cully
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

Re: [NF] MySQL equivalent for SPACE(nn)?

2007-05-24 Thread MB Software Solutions
Kevin Cully wrote: SELECT SPACE(6); Aaah! Nice...it's great that they respected us VFPers enough to make it the same! ;-) -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com Work smarter, not harder, with MBSS custom software

Re: [NF] MySQL equivalent for SPACE(nn)?

2007-05-24 Thread Kevin Cully
I am constantly amazed on how easy it is to translate VFP SQL syntax to MySQL syntax. Both great teams, must think alike! -Kevin CULLY Technologies, LLC Sponsor of FoxForward 2007 foxforward.net MB Software Solutions wrote: Kevin Cully wrote: SELECT SPACE(6); Aaah! Nice...it's great

Re: [NF] MySQL equivalent for SPACE(nn)?

2007-05-24 Thread Ted Roche
On 5/24/07, Kevin Cully [EMAIL PROTECTED] wrote: I am constantly amazed on how easy it is to translate VFP SQL syntax to MySQL syntax. Both great teams, must think alike! I think there's some fear of flying involved in there, too: I'm applying patterns and algorithms we used to solve problems