Differences

This shows you the differences between two versions of the page.

oracle-to-sql-server [October 11, 2017 6:02 am]
sqlines
oracle-to-sql-server [October 11, 2017 6:03 am] (current)
sqlines
Line 102: Line 102:
| 1 | CHR(//code//) | Get character from ASCII code | CHAR(//code//) || | 1 | CHR(//code//) | Get character from ASCII code | CHAR(//code//) ||
-| 2 | INSTR(//str, substr [,start]//) | Get position of substring | CHARINDEX(//substr, str [,start]//) {{:exclamation.png|}} <sup>param order</sup> ||+| 2 | INSTR(//str, substr [,start]//) | Get position of substring in string | CHARINDEX(//substr, str [,start]//) {{:exclamation.png|}} <sup>param order</sup> ||
|:::| INSTR(//str, substr, start, occur//) |:::| User-defined function || |:::| INSTR(//str, substr, start, occur//) |:::| User-defined function ||
| 3 | TRIM(//string//) | Trim leading and trailing spaces | LTRIM(RTRIM(//string//)) || | 3 | TRIM(//string//) | Trim leading and trailing spaces | LTRIM(RTRIM(//string//)) ||