search substring in a string ? Ms Access...

Question

1.00/5 (1 vote)

See more:

hi,
Question:-Search substring in a string using Ms Access Command line ...
exp:-
i have a line such as "There is a cat behind door"
i want to get "Behind" Word from the given line ...

Ms Access Database:-
Give
Told
Behind
rat

................................................
basically i want to search a substring in a long string ...
textbox contain that string ...
-------------------------------
thnxs in advance

Posted 1-Jul-15 20:27pm

Member 10521418

Add a Solution

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)

OriginalGriff · Answer 1 · 2015-07-01T20:59:00

Solution 1

This is complicated, but...

SQL

SELECT * FROM MyTable WHERE INSTR('There is a cat behind door', ' ' + UName + ' ') <> 0

Will do it.
The complications are that it won;t find them at the beginning of the string, or the end, it doesn't work with punctuation, and so forth: those I leave to you!

Personally, I wouldn't try to do it in SQL: I'd use a "proper" language with better string handling and presentation abilities, like C# or even VB.

Posted 1-Jul-15 20:59pm

OriginalGriff

Comments

Rohit Malhotra 2-Jul-15 3:13am

Uname ?

Rohit Malhotra 2-Jul-15 3:18am

INSTR? Uname?
whats thats Uname for column in db i guess and wat is instr ...?

OriginalGriff 2-Jul-15 3:21am

UName is a column name - I have no idea what names you gave your table data...
INSTR is an Access Function:
http://www.databasedev.co.uk/access-sql-string-functions.html

Member 10521418 2-Jul-15 3:22am

thxxxs let me try

Member 10521418 2-Jul-15 3:26am

the string was in a textbox how to implement that...

OriginalGriff 2-Jul-15 3:41am

Um...this is your homework, so you should do some of it yourself...:laugh:

Member 10521418 2-Jul-15 3:51am

okkkk originalgriff

Member 10521418 2-Jul-15 3:22am

okk thnnxs let me try ...