i'm having a problem with my SQL query. i'm trying to create another column with values based on the values of the other columns and call it sTitle. Every time i try to execute my SQL statement it brings back this error:
Illegal mix of collations for operation 'concat' Error No. 1271
I can't see anything wrong with my syntax but then again i'm kinda new to this. Here's my SQL:
SELECT CONCAT(rgMake,' ',IF(rgModel='ST','',CONCAT(rgModel,' ')),IF(rgWheels='2','Two','Single'),' Wheel Roll Grinder ',ROUND(inDiaCenter*25.4,0),IFNULL(CONCAT('/',ROUND(inDiaMax*25.4,0)),''),' mm Dia. ',ROUND(inFace*25.4,0),' mm Roll Face') AS sTitle
FROM tblMachine
WHERE rgBecameAvailable IS NOT NULL
ORDER BY rgWheels, ROUND(inDiaCenter*25.4,0), ROUND(inFace*25.4,0)
any advice would be greatly appreciated as this problem has been very frustrating to me. thanks in advance