Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    311

    Unanswered: find? instr? indexof?

    is there a sql keyword for find or instr?

    i have a field i wish to make into two and i need the position of a string "-" in the field so i can do a select right and copy that data to a new colm

  2. #2
    Join Date
    Dec 2004
    Location
    California, USA
    Posts
    93
    CHARINDEX
    Returns the starting position of the specified expression in a character string.

    Syntax
    CHARINDEX ( expression1 , expression2 [ , start_location ] )
    Whoever imagines himself a favorite with God holds others in contempt. - Robert Green Ingersoll, lawyer and orator (1833-1899)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •