Hello,

I have some problem with search a skills like c, c#, etc. by using Containstable .
My host provider does not change noise words. Due to this we are using below quarries

If users searching a keyword like C, then query is as follows…

select id,skills,[state],metroarea,designation,cname,jobtype,city,rank FROM peoplesurge_posting as posting INNER JOIN
containstABLE(peoplesurge_posting,(skills,[state],metroarea,designation,cname,jobtype,city),'ISABOUT ("c*")') as frees ON frees.[key]= posting.[id]


Note: 'ISABOUT (C)' for this it takes as a noice word then no rusults were displayed. Due to this we adding * to keyword c. this querry gives some results but it gives worng results i.e starting character of C
Like c, c++, c#......etc

Please resolve this problem ASAP. It’s very urgent for me.

Thanks,
Satish.