RE: returning empty columns

2006-02-28 Thread Price, Randall
lps. Randall Price VT.SETI.IAD.MIG:Microsoft Implementation Group http://vtmig.vt.edu [EMAIL PROTECTED] -Original Message----- From: 2wsxdr5 [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 28, 2006 3:43 AM To: mysql@lists.mysql.com Subject: returning empty columns This is probably going t

Re: returning empty columns

2006-02-28 Thread Rhino
- Original Message - From: "2wsxdr5" <[EMAIL PROTECTED]> To: Sent: Tuesday, February 28, 2006 3:43 AM Subject: returning empty columns This is probably going to sound like an odd request, but is there a way to return empty columns in Mysql. For example a roll call

returning empty columns

2006-02-28 Thread 2wsxdr5
This is probably going to sound like an odd request, but is there a way to return empty columns in Mysql. For example a roll call sheet I want to do a select of names from my table and then add a column for each of the next 12 weeks. I tried this. SELECT `Call`, concat(FName, ' ', LName