472,114 Members | 1,453 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,114 software developers and data experts.

Issue of Full text search -- ContainsTable


We have the full text search table and are using CONTAINSTABLE to search in the fulltext search column, its workingfine, but we have a requirement that we need to return results which match a particular sequence in word.

ex: The search text column has the word as 0203456-345567

if we give the input as " 0203456", the result is coming and showing the above column,

but if we search for " 203456" no results return,

Going through the net I found that we can perform search like "2034*" which will retun the result, ie we can add * at the end but can we have some command like "*2034", and this returning the results I could not get any such string even the FormOF is not giving me such output,

Can you please provide some way where I can use ContainsTable and also search for "*20345" string successfully.
Dec 23 '09 #1
0 1639

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Ravi Tallury | last post: by
1 post views Thread by Jay | last post: by
1 post views Thread by jeffejohnson | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.