Use AS to fix this Select silly_name+ as notSoSilly
Regards Dale Fraser http://learncf.com -----Original Message----- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Stephen M Sent: Friday, 12 October 2007 3:31 PM To: cfaussie Subject: [cfaussie] spaces in column names I'm trying to process a result set from a stored proc that contains spaces in the column names. Now, I've asked the db programmer to replace the spaces with underscores, just to make it easier for me, but exactly how do you reference the values of a column with spaces in the name? Bearing in mind that I won't always know the name of the column in advance. In one example the column name comes out as 03 OCT 2007 TO 10 OCT 2007. That will change week to week. regards, Stephen --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---