public String TO_CHAR(String columnName,int displayType,String AD_Language){
  StringBuffer retValue=new StringBuffer("CAST (");
  retValue.append(columnName);
  retValue.append(" AS Text)");
  return retValue.toString();
}

public String TO_CHAR ( String columnName , int displayType , String AD_Language ) { StringBuffer retValue = new StringBuffer ( "CAST (" ) ; retValue . append ( columnName ) ; retValue . append ( " AS Text)" ) ; return retValue . toString ( ) ; }
create sql for formatted date , number
