Display full version of the post: create/modify IF expression

fbastian
26.10.2009, 03:55
Hi all,
 
i am trying to get the data i am querying to show the below:
 
concat ( CONCAT ( CONCAT ( CONCAT (  CONSTRUCTION , '\n' ), '(' ),  ( If ( NO_CONDUCTORS, 'Unknown' , '____'  ) ) ), ')' )
 
i have apart from Unknown other values under this attribute but, when i use the above query it replaces all values with '____'.
can someone point out where i am going wrong?
 
thank you very much.
 
fbastian