Checks to see if a string in a sub-string inside another string

Microsoft:

 

Oracle:

  Function: INSTR('HelloWorld', 'W')

  Result: 6

Returns specified characters from character value string.

 

Microsoft:

 

Oracle:

  Function: SUBSTR('HelloWorld', 1, 5)

  Result: Hello

 

Converts alpha character values to lower case

 

MicroSoft:

 

 

Oracle:

  Function: LOWER('SQL Course')

  Result: sql course

Converts alpha character values to upper case

 

Microsoft:

 

Oracle:

  Function: UPPER('SQL Course')

  Result: SQL COURSE

Converts alpha character values to upper case for the first letter of each word; all other letters are in lower case

 

Microsoft:

 

Oracle:

  Function: INITCAP('SQL COURSE')

  Result: Sql Course

Concatenates the first character value to the second character value;

 

Microsoft:

 

Oracle:

  Function: CONCAT('Hello', 'World')

  Result: HelloWorld

  Note: You are limited to using 2 parameters for this function.

 

  Function: 'Hello' || 'World'

  Result: HelloWorld

Returns the number of characters in an expression

 

Microsoft:

 

Oracle:

  Function: LENGTH('HelloWorld')

  Result: 10

Returns an expression left-padded to a certain length of characters with a character expression.

 

Microsoft:

 

Oracle:

  Function: LPAD('Hello', 10, '*')

  Result: '*****Hello'

Returns an expression right-padded to a certain length of characters with a character expression.

 

Microsoft:

 

Oracle:

  Function: RPAD('Hello', 10, '*')

  Result: 'Hello*****'

Enables you to trim leading or trailing characters from a character string.

 

Microsoft:

 

Oracle:

  Function: TRIM('H' FROM 'HelloWorld')

  Result: 'elloWorld'

Searches a text expression for a character string and if found, replaces it with the specified replacement string.

 

Microsoft:

 

Oracle:

  Function: REPLACE('Jack and Jue', 'J', 'BL')

  Result: 'BLACK and BLUE'