SQL statement - 'chop' phrase

• monzulu

  Mr or Mrs. 500

  Points: 528

  More actions

  December 17, 2009 at 9:47 am

  #228615

  hi guys how do i do this SQL statements when a user typed in search text field in my ASP.net webpage? How do I 'chop' the typed-in phrases?

  examples:

  1. typed in phrase: marketing assistant jobs

  the resulting SQL statement should be:

  SELECT field1,field2

  FROM myTable

  WHERE CONTAINS(*, 'marketing AND assistant AND jobs')

  2. typed in phrase: public administration

  the resulting SQL would be:

  SELECT field1,field2

  FROM myTable

  WHERE CONTAINS(*, 'public AND administration')

  3. typed in phrase: SQL server full text search

  result would be:

  SELECT field1,field2

  FROM myTable

  WHERE CONTAINS(*, 'SQL AND server AND full AND text AND search')

  thanks for any ideas.

  .

• Lynn Pettis

  SSC Guru

  Points: 442447

  More actions

  December 17, 2009 at 10:32 am

  #1093605

  Does this help?

  select 'SQL full text search', replace('SQL full text search', ' ', ' AND ');

  You might consider giving BOL (Books Online, the SQL Server Help System) a shot. A good starting point mihgt be string functions.

  Edit: I tried this using variables, but it wouldn't post. Something here at work causes issues and it is frustrating.