Stuart McLachlan
stuart at lexacorp.com.pg
Sat Mar 16 08:50:58 CDT 2013
Try 'customers.Last Name' instead of customers.`Last Name' etc -- Stuart On 16 Mar 2013 at 8:35, Arthur Fuller wrote: > I've been staring at this expression too long and my eyes are beginning to > cross: > <,mysql> > SELECT > IF(ISNULL(customers.`Last Name`),customers.Company,CONCAT(customers.'First > Name',' ', customers.'Last Name')) as 'File As:' > from `customers` > </mysql> > > Syntax error. The Concat() part works fine in isolation so the problem is > not there > > TIA, > Arthur > _______________________________________________ > dba-Tech mailing list > dba-Tech at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-tech > Website: http://www.databaseadvisors.com >