Microsoft sql server sql-checking to see if part of a String exists

Question

I have a table called Employee with a field called address. I need to write a select that will retrieve all those rows from the table that whose address has a string or part of the string being passed.

So for instance, the address being passed to the query is "7745 Rutherford Rd, Jacksontown County". But the address field has records with only Jacksontown County. Not the entire one mentioned above and I need these rows to be retrieved too.

I tried using the LIKE operator but that will not work I think as the string being passed is longer than what we have in the database. Is there a better way to write this query?

Query:

SELECT * 
FROM Employee 
WHERE address LIKE '%7745 Rutherford Rd,Jacksontown County%'

Is there a better way than what? You didn't provide the query you are using now. More importantly is your question doesn't have enough context to make a lot of sense. — Sean Lange
– Sean Lange, Commented Jun 9, 2016 at 17:51
Maybe you should start here? spaghettidba.com/2015/04/24/… — Sean Lange
– Sean Lange, Commented Jun 9, 2016 at 17:52
Sorry about that.The query I tried was SELECT * FROM Employee WHERE address LIKE '%7745 Rutherford Rd,Jacksontown County%'. This query does not work.As I was trying to say above,the address field will have Jacksontown County only.I want those records to be retrieved too. — Krish Venkat
– Krish Venkat, Commented Jun 9, 2016 at 17:59
Add weaker conditions SELECT * FROM Employee WHERE address LIKE '%7745 Rutherford Rd%Jacksontown County%' or address LIKE '%Rutherford Rd%Jacksontown County%' or address LIKE '%Jacksontown County%' — Alex Kudryashev
– Alex Kudryashev, Commented Jun 9, 2016 at 18:06

Matt · Accepted Answer · 2016-06-09 18:05:44Z

0

You should pass each part of the string separately.

SELECT * 
FROM Employee 
WHERE address LIKE '%7745%' 
    or address LIKE '%Rutherford Rd%'
    or address LIKE '%Jacksontown County%'

answered Jun 9, 2016 at 18:05

Matt

8025 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Alex Kudryashev Over a year ago

Rutherford Rd exists not only in Jacksontown County ;(

Krish Venkat Over a year ago

what I am looking for is something else.Basically what I need is to retrieve all those rows from the table whose address field value matches part or the whole String being passed. The strings being passed are dynamically generated. Unfortunately in this forum since I cannot show the actual query that I am using,I was trying to come up with an example.Hope this is clearer.

Krish Venkat Over a year ago

another example.If I have a row in the table as TEST and if my searchString has 'THIS IS A TEST FOR TODAY',then that row needs to be retrieved.Not sure how to write a query for this,

Krish Venkat Over a year ago

I think I got something that might work. I referred to stackoverflow.com/questions/29389293/…. Thanks all for your help.

Collectives™ on Stack Overflow

Microsoft sql server sql-checking to see if part of a String exists

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related