> How do I get rid of the comma in the first value? You could try shifting to the left like
shift @columns if (undef $column[0]); then apply join as you have it. >Is the database returning a null field in the first >columns, is that why it's returning a comma? The answer to this question will avoid your problem in the first place. What database are you using? Is it that the first entry is deliberately left null as is deemed to be the case? Let the list know on the outcome. Alfred Vahau Uni. PNG ---------------------------- Subject: Join problem Date: Thu, 17 Oct 2002 04:47:41 -0700 (PDT) From: Vincent Lee <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Hello All, I've got a problem with the JOIN function I've got a list of columns that gets returned from the database. I push the column values into an array and then join them with a comma. The problem is that JOIN puts a comma in the first value. How do I get rid of the comma in the first value? Is the database returning a null field in the first columns, is that why it's returning a comma? join (",",@columns); ===== Regards, Vincent