select * from masterFL where descr LIKE '%green%' select * from masterFL where note LIKE '%green%'>I'm running the following lines and getting no errors. But also not getting any results what am I doing wrong?
>--create a catalog >EXEC sp_fulltext_catalog 'ims', 'create' > >--create table / PK >EXEC sp_fulltext_table 'masterFL', 'create', 'ims', 'pk_MasterFL' > >--Add some columns >EXEC sp_fulltext_column 'masterFL','Descr','add' >EXEC sp_fulltext_column 'masterFL','note','add' > >--Activate and populate the index >EXEC sp_fulltext_table 'masterFL', 'activate' >EXEC sp_fulltext_table 'masterFL', 'start_full' > >--activate and propagate >EXEC sp_fulltext_catalog 'ims', 'start_full' > >-- test it... >select * from masterFL where contains(descr, 'green') >select * from masterFL where contains(note, 'green') > >--To remove a full-text index >--EXEC sp_fulltext_table 'ims', 'drop' >