public String Frie_Name(String value){
  if (value == null || value.length() == 0)   return "";
  String retValue=value;
  String SQL="SELECT FRIE_Name(?) FROM DUAL";
  try {
    PreparedStatement pstmt=DB.prepareStatement(SQL,null);
    pstmt.setString(1,value);
    ResultSet rs=pstmt.executeQuery();
    if (rs.next())     retValue=rs.getString(1);
    rs.close();
    pstmt.close();
  }
 catch (  SQLException e) {
    log.log(Level.SEVERE,SQL,e);
  }
  return retValue;
}

public String Frie_Name ( String value ) { if ( value == null || value . length ( ) == 0 ) return "" ; String retValue = value ; String SQL = "SELECT FRIE_Name(?) FROM DUAL" ; try { PreparedStatement pstmt = DB . prepareStatement ( SQL , null ) ; pstmt . setString ( 1 , value ) ; ResultSet rs = pstmt . executeQuery ( ) ; if ( rs . next ( ) ) retValue = rs . getString ( 1 ) ; rs . close ( ) ; pstmt . close ( ) ; } catch ( SQLException e ) { log . log ( Level . SEVERE , SQL , e ) ; } return retValue ; }
frie value - convert to standardized name
