teradata instr

Sql:charindex (' String ', field) >0 charindex (' Administrator ', Muserid) >0 Oracle:instr (field, ' String ', 1,1) >0 InStr (Muserid, ' Administrator ', 1,1) >0 In the project to use the Oracle INSTR this function, by the way carefully learn this knowledge again. Oracle, you can use the INSTR function to judge a string to determine whether it contains the

InStr () returns the position of the string to be intercepted in the source string Grammar:InStr (Sourcestring,deststring,startposition,appearposition) Parameter description: Sourcestring: The source string to find in this string. Deststring: The string to find in the sourcestring. StartPosition: represents where to start the lookup in the sourcestring string. This parameter is optional if the default of 1 is ignored. If this parameter is a positive n

A function can use the InStr function to implement the simplicity of the code in a "Heterodoxy" way. The following is a typical example of whether a vowel letter is included in the string: 1, the common method: If ucase$ (char) = "A" or ucase$ (char) = "E" or ucase$ (char) = "I" or ucase$ (char) = "O" or ucase$ (char) = "U" Then ' It is a vowel End If 2. A more concise approach: If InStr ("Aaeeiioou

INSTR (STR,SUBSTR) searches for the specified character (SUBSTR) in a string (STR) and returns the position (INDEX) of the specified character;STR is searched for the string subs;tr the string you want to searchIn the string str, the first position (index) of the string substr appears, the index is calculated from 1, and if not found, returns 0 without returning a negative number.For example, the name of the query field named "Army" in the name, the t

Requirement: Sort a string that contains numbersAfter search, refer to http://www.cnblogs.com/m-cnblogs/archive/2012/03/30/2425938.htmlScreenshot:(To_number (str,split 1,...) InStr () Replace () substr ())TO_NUMBER(x [, format], [ nls_language ])Converts x to a NUMBER . X is the string, that would be, converted to a number. Format, optional, is the format, which is being used to convert X to a number. Nls_language, optional, is the NL

beginning of the 2 letter expression of some type of data has am, BM, CM and other types of data, and the other bits of the D field are 0-9 digitsBelow are the steps to analyze the problem:1. The index policy of the table is queried, the table is D > C > E (note: D, C, E are the fields of table tables)2. The index of D is invalidated and then queried with the above statement, but the use of the SELECT * from table t where t.d = ' AM1245 ' will undoubtedly be a disaster because it becomes a full

//----------------------------------------------------------------- Select avg (stu_oder_percent) from tb_sch_collect Result: Avg (stu_oder_percent ): 60.60962 //----------------------------------------------------------------- Select left (avg (stu_oder_percent), 4) from tb_sch_collect Result: Left (avg (stu_oder_percent), 4 ): 60.6 //----------------------------------------------------------------- Select right (avg (stu_oder_percent), 7) from tb_sch_collect Result: Right (avg (stu_oder_percen

Oracle's SUBSTR function simple usage SUBSTR (string, intercept start position, intercept length)//return the intercepted word substr (' Hello World ', 0, 1)//return result is ' H ' * to intercept a string with a length of 1 starting from the first character of the stringsubstr (' Hello World ', 1, 1)//Returns the result is ' H ' *0 and 1 are all representations of the start position of the intercept as the first charactersubstr (' Hello world ', 2,4)//return result to ' Ello 'substr (' Hello

Like vs instr efficiency 2010-12-03 16:59 The table has nearly 11 million data, many times we want to do string matching, in the SQL statement, we usually use like to achieve our search goals. But the actual test shows that the efficiency of like is quite different from the InStr function. Here are some test results: Sql> Set Timing onSql> Select COUNT (*) from T where