Semantic analysis exception: TO_CHAR function with (STRING, STRING) parameters - Solutions and alternatives

"Semantic analysis exception - function TO_CHAR cannot match any overloaded functions with (STRING, STRING), candidates are STRING TO_CHAR(BIGINT arg0); STRING TO_CHAR(BOOLEAN arg0); STRING TO_CHAR(DATE arg0, STRING arg1); STRING TO_CHAR(DATETIME arg0, STRING arg1); STRING TO_CHAR(DECIMAL(?,?) arg0); STRING TO_CHAR(DOUBLE arg0); STRING TO_CHAR(TIMESTAMP arg0, STRING arg1); STRING TO_CHAR(VOID arg0)"\n\nAccording to the exception message, the TO_CHAR function cannot find a matching overloaded function that accepts two STRING arguments. The available candidates are:\n\n- STRING TO_CHAR(BIGINT arg0)\n- STRING TO_CHAR(BOOLEAN arg0)\n- STRING TO_CHAR(DATE arg0, STRING arg1)\n- STRING TO_CHAR(DATETIME arg0, STRING arg1)\n- STRING TO_CHAR(DECIMAL(?,?) arg0)\n- STRING TO_CHAR(DOUBLE arg0)\n- STRING TO_CHAR(TIMESTAMP arg0, STRING arg1)\n- STRING TO_CHAR(VOID arg0)\n\nTo resolve this, examine your code to ensure the correct argument types are being passed to TO_CHAR. For instance, if you want to combine two strings, use the string concatenation operator "||" instead of TO_CHAR. If you need to use TO_CHAR with two string arguments, explore alternative functions or methods to achieve your desired outcome.