query problem
 

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

Re: query problem
 

can you have an IF statement in a SELECT?