SELECT SERVERPROPERTY('IsFullTextInstalled')
sp_fulltext_database 'enable'2. Then make a following query:
select id, code, name, photo_file_name, category_name category from item_master where contains((search,barcode),'*atta*') order by name OFFSET 0 ROWS FETCH NEXT 5 ROWS ONLY
Comments 0