Hi, I need to perform full text search for this keyword "CN-OPS-R0196.CN-OMP".
I am trying to search this using the keyword "CN-OPS-R0196".
This can only be searched when my word breaker settings on its column is English. I have tried using Neutral, Italian, German, etc, but none of them can search using the part keyword. Only english is searching it.
Can someone help as to how can we search the keyword in Neutral settings.
Eg: For Neutral Word breaker:
select * from [Table] where contains(Code, 'CN-OPS-R0196')
Result: No results
select * from [Table] where contains(Code, 'CN-OPS-R0196.CN')
Result: Returns all results.
When i give the full keyword, all languages word breaker settings are working correctly.