SQL Server Search Multiple columns of different datatypes with one Value

Question

So I have a table on a front end that is linked into my SQL Server backend. I can do paging and everything from there.

I'm trying to implement a good search function that can retrieve data across a variety of different columns the table has.

There is only one search bar, so I cannot search on each individual column separately.

An example of fields I have are

Field #
Requestor
Case #
Device Model
Submit Date

For whatever search term the user types in, using SQL Server I need to be able to search all the searchable columns and return rows where that value is similar to the search term.

I'm not sure how to begin or start with this, and how to also make it performant.

Khnshn · Accepted Answer · 2018-10-25 17:52:53Z

1

you could do something like select * from table where field# like '%input%' or requestor like %input% or case# like '%input%'... but I would recommend taking a look at sql full-text search

answered Oct 25, 2018 at 17:52

Khnshn

941 silver badge8 bronze badges

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

1 Comment

Oscar McCullough Over a year ago

SQL Full-Text-Search worked out the best. It's working fast for me and I can search each of the columns easily. Thanks!

Collectives™ on Stack Overflow

SQL Server Search Multiple columns of different datatypes with one Value

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related