Ending printjoin character issue and CONTAINS function not working (merged 2 threads) [message #272379] |
Thu, 04 October 2007 15:53 |
yumyumyeh
Messages: 8 Registered: October 2007
|
Junior Member |
|
|
? character has been designated as a printjoin character through preferences.
I am trying to search a record containing the following literal word: this?
eg: How About This?
I am issuing my query like this:
select * from table where contains(column, ' this\? ') > 0
This does return my wanted records which contains this?
but it also returns all records simply containing 'this'. (No ? after 'this'). So basically it is ignoring the ? character
even though i have escaped it using \.
Is this a known issue or a bug? Is there a solution.
Any help is greatly appreciated.
[Updated on: Fri, 05 October 2007 10:46] Report message to a moderator
|
|
|