Chris,
See if this works for you:
SELECT
' ' as 'Call'
, concat(FName, ' ', LName) as Name
, ' ' as 'Mar-6'
, ' ' as 'Mar-13'
, ' ' as 'Mar-20'
, ' ' as 'Mar-27'
FROM
table
ORDER BY
LName, FName
Notice that there is a single blank space being ret
- 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 sheet I want to d
