Concatenate String and Pass to FORMSOF?

[HumanJHawkins]

The following query works perfectly (returning all words on a list called
"Dolch" that do not contain a form of "doing"):

SELECT 'Dolch' AS[List Name], dbo.Dolch.vchWo rd
FROM dbo.Dolch LEFT OUTER JOIN
dbo.CombinedLex icons ON CONTAINS(dbo.Do lch.vchWord,
'FORMSOF(INFLEC TIONAL, "doing")')
WHERE (dbo.CombinedLe xicons.vchWord IS NULL)

However, what I really want to do requires me to piece two strings together,
resulting in a word like "doing". Any time I try to concatinate strings to
get this parameter, I get an error.

For example:

SELECT 'Dolch' AS[List Name], dbo.Dolch.vchWo rd
FROM dbo.Dolch LEFT OUTER JOIN
dbo.CombinedLex icons ON CONTAINS(dbo.Do lch.vchWord,
'FORMSOF(INFLEC TIONAL, "do' + 'ing")')
WHERE (dbo.CombinedLe xicons.vchWord IS NULL)

I have also tried using & (as in "do' & 'ing") and various forms of single
and double quotes. Does anyone know a combination that will work?

FYI, in case this query looks goofy because of the unused "CombinedLexico ns"
table, it is because the end result should be a working form of the
following...
Figuring out the string concatination is just a step toward this goal:

SELECT 'Dolch' AS[List Name], dbo.Dolch.vchWo rd
FROM dbo.Dolch LEFT OUTER JOIN
dbo.CombinedLex icons ON CONTAINS(dbo.Do lch.vchWord,
'FORMSOF(INFLEC TIONAL, ' + dbo.CombinedLex icons.vchWord + ')')
WHERE (dbo.CombinedLe xicons.vchWord IS NULL)

Thanks!

[Hilary Cotter]

Would this work for you?

declare @string varchar(2000)
declare @searchphrase varchar(200)
set @searchphrase=' do ing'
set @string='SELECT [Dolch] AS[List Name], dbo.Dolch.vchWo rd '
select @string=@string + ' FROM dbo.Dolch LEFT OUTER JOIN'
select @string=@string + ' dbo.CombinedLex icons ON
CONTAINS(dbo.Do lch.vchWord,''F ORMSOF(INFLECTI ONAL, '
select @string=@string +replace(@searc hphrase,' ','')
select @string=@string +')'' WHERE (dbo.CombinedLe xicons.vchWord IS NULL)'
print @string


--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"HumanJHawk ins" <No****@NoSpam. Net> wrote in message
news:ZG******** *********@newsr ead1.news.pas.e arthlink.net...

The following query works perfectly (returning all words on a list called
"Dolch" that do not contain a form of "doing"):

SELECT 'Dolch' AS[List Name], dbo.Dolch.vchWo rd
FROM dbo.Dolch LEFT OUTER JOIN
dbo.CombinedLex icons ON CONTAINS(dbo.Do lch.vchWord,
'FORMSOF(INFLEC TIONAL, "doing")')
WHERE (dbo.CombinedLe xicons.vchWord IS NULL)

However, what I really want to do requires me to piece two strings together, resulting in a word like "doing". Any time I try to concatinate strings to
get this parameter, I get an error.

For example:

SELECT 'Dolch' AS[List Name], dbo.Dolch.vchWo rd
FROM dbo.Dolch LEFT OUTER JOIN
dbo.CombinedLex icons ON CONTAINS(dbo.Do lch.vchWord,
'FORMSOF(INFLEC TIONAL, "do' + 'ing")')
WHERE (dbo.CombinedLe xicons.vchWord IS NULL)

I have also tried using & (as in "do' & 'ing") and various forms of single
and double quotes. Does anyone know a combination that will work?

FYI, in case this query looks goofy because of the unused "CombinedLexico ns" table, it is because the end result should be a working form of the
following...
Figuring out the string concatination is just a step toward this goal:

SELECT 'Dolch' AS[List Name], dbo.Dolch.vchWo rd
FROM dbo.Dolch LEFT OUTER JOIN
dbo.CombinedLex icons ON CONTAINS(dbo.Do lch.vchWord,
'FORMSOF(INFLEC TIONAL, ' + dbo.CombinedLex icons.vchWord + ')')
WHERE (dbo.CombinedLe xicons.vchWord IS NULL)

Thanks!

[HumanJHawkins]

"Hilary Cotter" <hi***********@ gmail.com> wrote in message
news:Or******** ******@TK2MSFTN GP09.phx.gbl...

Would this work for you?

declare @string varchar(2000)
declare @searchphrase varchar(200)
set @searchphrase=' do ing'
set @string='SELECT [Dolch] AS[List Name], dbo.Dolch.vchWo rd '
select @string=@string + ' FROM dbo.Dolch LEFT OUTER JOIN'
select @string=@string + ' dbo.CombinedLex icons ON
CONTAINS(dbo.Do lch.vchWord,''F ORMSOF(INFLECTI ONAL, '
select @string=@string +replace(@searc hphrase,' ','')
select @string=@string +')'' WHERE (dbo.CombinedLe xicons.vchWord IS NULL)'
print @string

It's taking me a while to see if this will work. Thanks for the suggestion.
It looks like a good path to take.