Convert a field to CHAR but result is truncated

[xarapre7]

Hi Experts!

I'm trying to convert a VARCHAR field to CHAR as it's giving IE2 result.  I used this in the extract

SELECT

=IIf(len([FIELD]) > 1, '_'+Cast([FIELD] as CHAR),[FIELD]) AS [FIELD] 

but this is truncating the result from

{IT CONTROLROOM - LABELED MED INTERFACE} to {IT CONTROLROOM - LABELED MED}.

How should i correct this? Thanks in advance.

[marcus_sommer]

Within Qlik it's meaningless if a field within a sql-database is a varchar or a char. Therefore you might not need this converting. Most often it's preferable to use a Preceding Load to perform any transformations on the sql-output.

- Marcus