Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
1 Cards in this Set
- Front
- Back
Explain charindex function in sybase?
|
Description : Returns an integer representing the starting position of an expression.
Syntax: charindex(expression1,expression2) Parameters expression is a binary or character column name, variable or constant expression. Can be char, varchar, nchar, nvarchar, unichar or univarchar data, binary or varbinary. Examples Example 1 Returns the position at which the character expression “wonderful” begins in the notes column of the titles table: select charindex("wonderful", notes) from titles where title_id = "TC3218" ----------- 46 For More info:http://infocenter.sybase.com/help/index.jsp?topic=com.sybase.help.ase_15.0.sqlug/html/sqlug/sqlug642.htm |