Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Database & SysAdmin
  3. Database
  4. Sql Match

Sql Match

Scheduled Pinned Locked Moved Database
databasedesignregex
1 Posts 1 Posters 11 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • M Offline
    M Offline
    Member_14890678
    wrote on last edited by
    #1

    I have this query where I search for "put up" and it returns a paragraph where I have verified that the match is "put-ting". (If the word is misspelled it does not matter, it is not a coincidence).

    SELECT SQL_TABLE.*, FT.* FROM [Libro_Miguel De Cervantes Saavedra - Don Quixote de la Mancha] AS SQL_TABLE
    INNER JOIN CONTAINSTABLE([Libro_Miguel De Cervantes Saavedra - Don Quixote de la Mancha], [Contenido],
    '"put up"') AS FT
    ON FT.[KEY] = SQL_TABLE.Id WHERE (ESTADO IS NULL OR ESTADO = ' ') ORDER BY RANK, Pagina, Parrafo, Linea, Palabra

    Now, these dispositions being made, he would no longer defer put-ting his design in execution, being the more strongly excited thereto by the mischief he thought his delay occasioned in the world; such and so many were the grievances he proposed to redress, the wrongs he intended to rectify, the exorbitances to correct, the abuses to reform, and the debts to discharge. And therefore, without making any one privy to his design, or being seen by anybody, one morning before day (which was one of the hottest of the month of July) he armed himself cap-a-pie, mounted Rosinante, adjusted his ill— composed beaver, braced on his target, grasped his lance, and issued forth into the fields at a private door of his backyard, with the great— est satisfaction and joy, to find with how much ease he had given a beginning to his honourable enterprise. But scarcely was he got into the plain, when a terrible thought assaulted him and such as had well nigh made him abandon his new undertaking; for it came into his remembrance, that he was not dubbed a knight, and that according to the laws of chivalry, he neither could nor ought to enter the lists against any knight: and though he had been dubbed, still he must wear white armour, as a new knight, without any device on his shield, until he had acquired one by his prowess. These reflections staggered his resolution; but his frenzy prevailing above any reason whatever, he purposed to get himself knighted by the first person he should meet, in imitation of many others who had done the like, as he had read in the books which had occasioned his madness. As to the white armour, he proposed to scour his own, the first opportun— ity, in such sort that it should be whiter than ermine: and herewith quieting his mind, he went on his way, following no other road than what his horse pleased to take; believing that therein consisted the life and spirit of adventures.

    1 Reply Last reply
    0
    Reply
    • Reply as topic
    Log in to reply
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes


    • Login

    • Don't have an account? Register

    • Login or register to search.
    • First post
      Last post
    0
    • Categories
    • Recent
    • Tags
    • Popular
    • World
    • Users
    • Groups