• Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

Card Range To Study

through

image

Play button

image

Play button

image

Progress

1/1

Click to flip

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