need help in searching a sentence

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

Hi all

Please tell me how to code to search a full sentence in C# application..
e.g. "What is your name"-i want to search this
so if all words are present then it should return the same else if few words matches then that also it should return..

i m using sql-server 2005 and visual studio 2008

waiting for ur replies.
Thank you

Posted 8-Oct-12 23:26pm

Code-Hunt

Updated 8-Oct-12 23:49pm

v3

Add a Solution

Comments

bbirajdar 9-Oct-12 5:42am

Tell us what have you tried so that we can suggest some new solutions for you...

[no name] 9-Oct-12 5:44am

i tried using like operator..but when i m putting the whole question then it is not working...

Mohd. Mukhtar 9-Oct-12 5:52am

you need to write a function with reqex to do like statement task.

[no name] 9-Oct-12 5:53am

please give me some example how to do this

Kschuler 9-Oct-12 16:28pm

It would help if you would provide a few examples of what you are searching, what you are searching for, and what result you are expecting.

Akinmade Bond 9-Oct-12 7:44am

To find a sentence, you can search for punctuations. All sentences end with either a fullstop('.'), a question mark('?') or an exclamation('!'). So, just perform a search usin regex or any other method you can think of.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mohd. Mukhtar · Answer 1 · 2012-10-08T23:46:00

Write a stored procedure and in that stored procedure write 3 query as below

C#

query1 = SELECT * FROM tableName WHERE cloumnName like RegExpForExactMatch; 
query2 = SELECT * FROM tableName WHERE cloumnName like RegExpForAllMatch; 
query3 = SELECT * FROM tableName WHERE cloumnName like RegExpForAnyMatch;

And then execute the query with the union;

Hope this will help you.