Premium Essay

Lcase

In: Other Topics

Submitted By desair
Words 17158
Pages 69
No. 12-3

pìéêÉãÉ=`çìêí=çÑ=íÜÉ=råáíÉÇ=pí~íÉë=
_______________ JACKIE HOSANG LAWSON AND JONATHAN M. ZANG, v. FMR LLC, ET AL., _______________ Respondents. Petitioners,

IN THE

On Writ Of Certiorari To The United States Court Of Appeals For The First Circuit

_______________

BRIEF FOR RESPONDENTS

_______________

STEPHEN M. SHAPIRO TIMOTHY S. BISHOP MAYER BROWN LLP 71 South Wacker Drive Chicago, IL 60606 (312) 706-8684

MARK A. PERRY Counsel of Record PORTER N. WILKINSON GEOFFREY C. WEIEN GIBSON, DUNN & CRUTCHER LLP 1050 Connecticut Avenue, N.W. Washington, D.C. 20036 (202) 955-8500 mperry@gibsondunn.com RACHEL S. BRASS GIBSON, DUNN & CRUTCHER LLP 555 Mission Street Suite 3000 San Francisco, CA 94105 (415) 393-8200

Counsel for Respondents

QUESTION PRESENTED Section 806 of the Sarbanes-Oxley Act of 2002 provides “[w]histleblower protection for employees of publicly traded companies.” 18 U.S.C. § 1514A(a). The question presented is whether this provision covers only employees of public companies.

ii LIST OF PARTIES Respondents FMR LLC, Fidelity Management & Research Company, FMR Co., Inc., and Fidelity Brokerage Services LLC disclose the following information: The named defendant FMR Corp. was merged into a limited liability company prior to the filing of the complaints in this action. FMR LLC is the surviving entity; FMR Corp. no longer exists. FMR LLC is the parent of Fidelity Management & Research Company. FMR Co., Inc. and Fidelity Brokerage Services LLC are indirect subsidiaries of FMR LLC. FMR LLC is not publicly held, and no publicly held corporation owns 10% or more of Fidelity Management & Research Company, FMR Co., Inc., or Fidelity Brokerage Services LLC.

iii TABLE OF CONTENTS Page STATEMENT .............................................................. 1 SUMMARY OF ARGUMENT ..................................... 5 ARGUMENT…...

Similar Documents

Free Essay

Enginerring Manager

...'Science'); select p.product_name, p.supplier_name, (select order_id from order_items where product_id = 101) as order_id from product p where p.product_id = 101 SELECT p.product_name FROM product p  WHERE p.product_id = (SELECT o.product_id FROM order_items o  WHERE o.product_id = p.product_id); * AVG() - Returns the average value * COUNT() - Returns the number of rows * FIRST() - Returns the first value * LAST() - Returns the last value * MAX() - Returns the largest value * MIN() - Returns the smallest value * SUM() - Returns the sum SQL Scalar functions SQL scalar functions return a single value, based on the input value. Useful scalar functions: * UCASE() - Converts a field to upper case * LCASE() - Converts a field to lower case * MID() - Extract characters from a text field * LEN() - Returns the length of a text field * ROUND() - Rounds a numeric field to the number of decimals specified * NOW() - Returns the current system date and time * FORMAT() - Formats how a field is to be displayed * The UNION operator is used to combine the result-set of two or more SELECT statements. An SQL JOIN clause is used to combine rows from two or more tables, based on a common field between them. The most common type of join is: SQL INNER JOIN (simple join). An SQL INNER JOIN return all rows from multiple tables where the join condition is met. * Notice that each SELECT statement within the UNION must......

Words: 652 - Pages: 3

Free Essay

Boolean Assignment

...property of a text box? When you compare the Text property of a text box with another value the Text property behaves like a variant. Visual Basic compares one text box to another as strings and compares a text box to a numeric variable or constant with a numeric compare. You can force a numeric comparison on a Text property by using the Val function. 6 . Why would it be useful to include the ToUpper method in a comparison? When comparing strings, the case of the characters is important. An uppercase “Y” does not compare equal to a lowercase “y”. Since the user may type a name or word in either uppercase or lowercase or a combination of the two, we must check all possibilities. The easiest way is to use the string function Ucase or Lcase, which returns the uppercase or lowercase equivalency of a string, respectively. 7. Name the types of items that can be used in a comparison. The conditions to be tested can be formed with numeric variables and constants, string variables and constants, object properties, and arithmetic expressions. However, it is important to note that comparisons must be made on “like types”; that is, strings can be compared only to other strings, and numeric values can be compared only to other numeric values, whether a variable, constant, property, or arithmetic expression. 8. Explain a Boolean variable test for True and False. Give an example. Visual Basic evaluates the condition in an If statement. If the condition is a Boolean variable name,......

Words: 902 - Pages: 4

Free Essay

Vb Script

...indicates whether a specified variable is an array | Join | Returns a string that consists of a number of substrings in an array | LBound | Returns the smallest subscript for the indicated dimension of an array | Split | Returns a zero-based, one-dimensional array that contains a specified number of substrings | UBound | Returns the largest subscript for the indicated dimension of an array | String Functions | Top | Function | Description | InStr | Returns the position of the first occurrence of one string within another. The search begins at the first character of the string | InStrRev | Returns the position of the first occurrence of one string within another. The search begins at the last character of the string | LCase | Converts a specified string to lowercase | Left | Returns a specified number of characters from the left side of a string | Len | Returns the number of characters in a string | LTrim | Removes spaces on the left side of a string | RTrim | Removes spaces on the right side of a string | Trim | Removes spaces on both the left and the right side of a string | Mid | Returns a specified number of characters from a string | Replace | Replaces a specified part of a string with another string a specified number of times | Right | Returns a specified number of characters from the right side of a string | Space | Returns a string that consists of a specified number of spaces | StrComp | Compares two strings and returns a......

Words: 1154 - Pages: 5

Free Essay

Baniter Group

...witnesses. How could this large scale of money laundering, debt write off’s and sweetheart loans go go on for fourteen years undetected by the government’s financial gatekeepers? All the improvements that were made to the banks ineffeciencys and poor communtiocation could not over come the sneaky, depraved and money hungry actions of the family that own the majority of it. References Bank, P. N. C., & National Association. (2011). Bank of America. NA (as Administrative Agent and Collateral Agent) is incorporated herein by reference from Exhibit (10)(3) of the Company’s Form. Retrieved from http://www.wvcsd.org/District/boe/minutes/1112/pdf/ApprovedMinutesBOEReorgMtg07_11_11.pdf Fishel, B & Conger, J. (2009). Banco Intercontinental lCase Study. Best practices in talent management. Thomke, S. (2003). R&D comes to services. Bank of America's pathbreaking experiments. Harvard Business Review, 81(4), 70. Retrieved from http://www.ncbi.nlm.nih.gov/pubmed/12687921 Turney, P. D. (2002). Thumbs up or thumbs down?: semantic orientation applied to unsupervised classification of reviews. In Proceedings of the 40th annual meeting on association for computational linguistics (pp. 417-424). Association for Computational Linguistics....

Words: 1453 - Pages: 6

Free Essay

Hostel Management System

...If End Sub Private Sub mnufind_Click() On Error Resume Next If Text1.Enabled = True Then MsgBox "Save record first", vbInformation, "Message" Else Dim f f = InputBox("Input Bill ID No. or Family name", "Find") If f <> "" Then Data1.RecordSource = ("select * from tblebill where ServiceIDNo = '" & f + "' or FamilyName= '" & f + "'") Data1.Refresh End If If Text1.Text = "" Then MsgBox "Record does not exist", vbInformation, "Message" Data1.RecordSource = "select * from tblebill where ServiceIDNo <> '""'" Data1.Refresh End If End If End Sub Private Sub mnunew_Click() On Error Resume Next Dim n n = InputBox("Please supply password or type 'cancel' to undo", "Message") n = LCase(n) If n = "sana" Then Data1.Recordset.AddNew mnunew.Enabled = False mnuedit.Enabled = False mnusave.Enabled = True Toolbar1.Buttons(5).Enabled = False Toolbar1.Buttons(4).Enabled = False Toolbar1.Buttons(2).Enabled = True txtstudnoctr.Text = Val(txtstudnoctr.Text) + 1 Text1.Text = Format$(txtstudnoctr.Text, "00") cmdenabled_Click txtstatus.Text = "Connected" Text2.SetFocus ElseIf n = "cancel" Then MsgBox "Adding new service ID number cancel", vbInformation, "Message" ElseIf n = "" Then 'do nothing Else MsgBox "Invalid password", vbCritical, "Message" mnunew_Click End If End Sub Private Sub mnupreview_Click() On Error Resume Next If Text1.Enabled = True Then MsgBox "Save record......

Words: 3691 - Pages: 15

Premium Essay

Sql Tutorial Basics

....................................... 189 EXPORT_SET(bits,on,off[,separator[,number_of_bits]]) ........................ 189 FIELD(str,str1,str2,str3,...) ...................................................................... 189 FIND_IN_SET(str,strlist)......................................................................... 189 FORMAT(X,D) ........................................................................................ 189 HEX(N_or_S) ......................................................................................... 190 INSERT(str,pos,len,newstr) .................................................................... 190 INSTR(str,substr) ................................................................................... 190 LCASE(str) ............................................................................................. 191 LEFT(str,len) .......................................................................................... 191 LENGTH(str) .......................................................................................... 191 LOAD_FILE(file_name) .......................................................................... 191 LOCATE(substr,str), LOCATE(substr,str,pos) ........................................ 191 LOWER(str)............................................................................................ 192 LPAD(str,len,padstr) ............................................................................... 192 LTRIM(str) ....................

Words: 38789 - Pages: 156

Premium Essay

Sql Tutorial

....................................... 189 EXPORT_SET(bits,on,off[,separator[,number_of_bits]]) ........................ 189 FIELD(str,str1,str2,str3,...) ...................................................................... 189 FIND_IN_SET(str,strlist)......................................................................... 189 FORMAT(X,D) ........................................................................................ 189 HEX(N_or_S) ......................................................................................... 190 INSERT(str,pos,len,newstr) .................................................................... 190 INSTR(str,substr) ................................................................................... 190 LCASE(str) ............................................................................................. 191 LEFT(str,len) .......................................................................................... 191 LENGTH(str) .......................................................................................... 191 LOAD_FILE(file_name) .......................................................................... 191 LOCATE(substr,str), LOCATE(substr,str,pos) ........................................ 191 LOWER(str)............................................................................................ 192 LPAD(str,len,padstr) ............................................................................... 192 LTRIM(str) ....................

Words: 39505 - Pages: 159

Free Essay

John Walkenbach - Excel Vba Programming

...specified part of a given date — for example, a date’s day of the year. Converts a date to a serial number. Converts a string to a date. Returns the day of the month from a date value. Returns the name of a file or directory that matches a pattern. Returns the line number that caused an error. Returns the error number of an error condition. Returns the error message that corresponds to an error number. Returns the base of the natural logarithm (e) raised to a power. (continued) DatePart DateSerial DateValue Day Dir Erl Err Error Exp 134 Part III: Programming Concepts Table 9-2 (continued) Function FileLen Fix Format GetSetting Hex Hour InputBox InStr Int IPmt IsArray IsDate IsEmpty IsError IsMissing IsNull IsNumeric IsObject LBound LCase Left Len Log LTrim Mid Minute Month MsgBox Now RGB What It Does Returns the number of bytes in a file. Returns a number’s integer portion. Displays an expression in a particular format. Returns a value from the Windows registry. Converts from decimal to hexadecimal. Returns the hours portion of a time. Displays a box to prompt a user for input. Returns the position of a string within another string. Returns the integer portion of a number. Returns the interest payment for an annuity or loan. Returns True if a variable is an array. Returns True if an expression is a date. Returns True if a variable has not been initialized. Returns True if an expression is an error value. Returns True if an optional argument was not passed to a......

Words: 98776 - Pages: 396

Premium Essay

Sql Book

...items found in a data dictionary include synonyms for attributes, detailed descriptions of each table and attribute in the database, referential integrity constraints, and database schema definitions. The DBMS updates the system catalog automatically when users make change to the database, such as creating, altering, or dropping tables or creating or dropping indexes. Use the CHECK clause of the ALTER TABLE command. Use the ADD FOREIGN KEY clause of the ALTER TABLE command. 297 CHAPTER 8—SQL FUNCTIONS AND PROCEDURES 1. Use the UPPER function to display letters in uppercase in Oracle and SQL Server. In Access, use the UCASE() function. Use the LOWER function to display letters in lowercase in Oracle and SQL Server. In Access, use the LCASE() function. To add months to a date, use the ADD_MONTHS function (Oracle), or the DATEADD() function (Access and SQL Server). To add days to a date, add the desired number of days to a date. To find the number of days between two dates, subtract the earlier date from the later date. In Oracle, separate the column names with two vertical lines (||) in the SELECT clause. In SQL Server, separate the column names with the + symbol. In Access, separate the column names with the & symbol. A stored procedure is a file that is stored on a server and contains commands that can be used repeatedly. Stored procedures eliminate the need for users to retype a query each time it is needed. In PL/SQL procedures, you declare variables first before any......

Words: 48772 - Pages: 196

Premium Essay

Intro to Linux

...with a NEWLINE character), outputs a block of text without the NEWLINE. Each output block has the size given by the bs or obs argument and is created by adding trailing SPACE characters to the text until it is the proper size. Converts ASCII-encoded characters to EBCDIC, allowing you to write tapes for use on IBM mainframe and similar computers. Converts uppercase letters to lowercase while copying data. If a read error occurs, dd normally terminates. This conversion allows dd to continue processing data and is useful when you are trying to recover data from bad media. Does not truncate the output file before writing to it. Converts lowercase letters to uppercase while copying data. Performs the opposite of the block conversion. ebcdic lcase noerror notrunc ucase unblock Notes Under Linux, you can use the standard multiplicative suffixes to make it easier to specify large block sizes. See Table V-1 on page 603. Under Mac OS X, you can use some of the standard multiplicative suffixes; however, OS X uses lowercase letters in place of the uppercase letters shown in the table. In addition, under OS X, dd supports b (block; multiply by 512) and w (word; multiply by the number of bytes in an integer). You can use dd to create a file filled with pseudo-random bytes. $ dd if=/dev/urandom of=randfile2 bs=1 count=100 Examples The preceding command reads from the /dev/urandom file (an interface to the kernel’s random number generator) and writes to the file named......

Words: 228961 - Pages: 916

Premium Essay

Access Tutorial

...digits “07” Seconds, no leading zero “9” Seconds, two digits “09” Named formats (local format) Format(2.3, "Currency") = "£2.30" (in UK) also "Percent", "Yes/No", "Long Date" . . . 6. Visual Basic reference 127 6.5 Other functions String functions String functions work on strings and characters. Figure 6.5A shows the most important ones. Asc(s) takes the first character of s and returns it as an integer, the Ascii code for that character. Chr(c) works the other way and returns an Ascii code as a string of one character. A set of functions return the length of a string (Len), extract the left, right or middle part of a string (Left, Right, Mid), or trim a string of leading or trailing spaces (LTrim, RTrim, Trim). The functions LCase and UCase transform all letters to upper or lower case. Space(n) generates a string of n spaces. Comparing strings is in principle easy, in practice difficult due to regional variations of the alphabet, how to treat upper and lower case letters, etc. In each module, you can specify how strings are to be compared. They may be compared according to their Ascii codes (Option Compare Binary), according to the regional alphabet and without case sensitivity (Option Compare Text), or according to the rules of the database (Option Compare Database). In the Access database engine, Option Compare Database seems to work exactly as Option Compare Text. The function StrComp(s1, s2) compares s1 to find out whether s1 comes before s2 in the......

Words: 54671 - Pages: 219

Free Essay

Konbanwa

...what MySQL is here to handle. By using the appropriate collation, you can choose the sort order you want. 10.4. Operations Affected by Character Set Support This section describes operations that take character set information into account as of MySQL 4.1. 10.4.1. Result Strings MySQL has many operators and functions that return a string. This section answers the question: What is the character set and collation of such a string? For simple functions that take string input and return a string result as output, the output's character set and collation are the same as those of the principal input value. For example, UPPER(X) returns a string whose character string and collation are the same as that of X. The same applies for INSTR(), LCASE(), LOWER(), LTRIM(), MID(), REPEAT(), REPLACE(), REVERSE(), RIGHT(), RPAD(), RTRIM(), SOUNDEX(), SUBSTRING(), TRIM(), UCASE(), and UPPER(). (Also note: The REPLACE() function, unlike all other functions, ignores the collation of the string input and performs a case-insensitive comparison every time.) For operations that combine multiple string inputs and return a single string output, the ``aggregation rules'' of standard SQL apply: • • • • If an explicit COLLATE X occurs, then use X If an explicit COLLATE X and COLLATE Y occur, then error Otherwise, if all collations are X, then use X Otherwise, the result has no collation For example, with CASE ... WHEN a THEN b WHEN b THEN c COLLATE X END, the resultant collation is X. The same......

Words: 470488 - Pages: 1882

Premium Essay

Access 2007

...blank space, followed by the state name, followed by two blank spaces, followed by the ZIP code: [City] & “, “ & [State] & “ “ & [ZIP] An example of the preceding expression may look something like this: Los Angeles, CA 91234 Using the Access Text functions Access provides several functions for working with text. You find them in the Text category in the middle column of the Expression Builder. We focus on some of the more commonly used functions and show examples of their usage. For information on more Text functions and additional details, use the Help button in the Expression Builder. Table 2-6 lists the more common Text functions. Book III Chapter 2 Table 2-6 Function and Syntax LCase(string) Examples of Built-in Text Functions Returns Example string converted to LCase(“AbCdEfG”) lowercase returns abcdefg string converted to UCase(“AbCdEfG”) UCase(string) uppercase returns ABCDEFG Leftmost n characters of Left(“abcdefg”,3) Left(string,n) string returns abc Rightmost n characters of Right(“abcdefg”,2) Right(string,n) string returns fg Middle length characters Mid(“abcmnyz”,4,2) Mid(string, start[, length]) of string starting at start returns mn Len(string) Length of string Len(“Howdy”) returns 5 string with any leading and Trim(“ abc “) Trim(string) trailing spaces trimmed off returns abc Position of string2 in InStr(“abcxdef”,”x”) InStr([start,] string1, string2) string1 starting at start returns 4 (because x is the fourth character in......

Words: 190131 - Pages: 761