Convert Numeric value to string

[AXK0121B]

We wanted to Convert a numeric value to String and then check the length of the string and if it exceeding 255 we need to get first 255 char or we need to load it as it is.

Below is the Code we are using , the case statement is working as the data is coming as numeric the code is failing

case when
length($code_value) > 255 then substr($code_value,1,instr($code_value, ";")+250)
else
$code_value
end

Is there a way we convert numeric to string.

[Heinvandenheuvel]

A number 255 characters long? How can that be? Maybe we need to see some examples success/fail

>> Is there a way we convert numeric to string.  

Just contatenate with an empty string:     '' || $var

Similar to force to go from string to number :  0 + $var

Hein