SQL statement - 'chop' phrase

  • 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.

Viewing post 1 (of 2 total)

You must be logged in to reply to this topic. Login to reply