This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
dev:sql:functions:position [2009/12/05 00:34] tdo created |
dev:sql:functions:position [2012/10/26 14:28] (current) |
||
|---|---|---|---|
| Line 8: | Line 8: | ||
| String comparisons are case-sensitive. Use the UPPER and LOWER functions around string1 and string2 to produce a case-insensitive search. | String comparisons are case-sensitive. Use the UPPER and LOWER functions around string1 and string2 to produce a case-insensitive search. | ||
| ===== Syntax ===== | ===== Syntax ===== | ||
| - | POSITION(string1 IN string2) | + | POSITION( <column_spec | 'string1' > IN < column_spec | 'string2' > ) |
| == string1 == | == string1 == | ||
| - | Required. Any valid text string. The text to search for. | + | Required. Any column_spec or valid text string. The text to search for. |
| == IN == | == IN == | ||
| Line 17: | Line 17: | ||
| == string2 == | == string2 == | ||
| - | Required. Any valid text string. The text in which to search for string1. | + | Required. Any column_spec or valid text string. The text in which to search for string1. |
| ===== Example ===== | ===== Example ===== | ||
| ==== Example 1 ==== | ==== Example 1 ==== | ||