April 15, 2002 at 11:02 am
Hello, I have a problem with a full-text search that I'd apprecicate some help with :-
I have a column called 'txt' on a full-text enabled table called ft and I run the following query :-
select * from ft where contains(txt,'"6W*"')
The behaviour I require is to return any records which have a word within txt that begins with '60W' (e.g. '60Wabc fg' or 'werw 60Wsdffd') but when I execute the above query the following records are returned :- '600W', '6000W', '6WW' but not '6000WW'. Has anyone else witnesed this behaviour with
numerics mid-string? (The query executes exactly as required if there are no numerics mid-string).
Thanks for any help, Andy.
.
April 15, 2002 at 4:00 pm
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply