Searching trough more than 1 column 1

[007700]

Hi there,

Maybe my problem is very simple, maybe not bur I can't seem to solve it.

I have created a query that will look trough a column for a value that I give in.
I do this with the statement
Like '*' & [What is the IP?] & "*"
in the criteria field. I would like the search to look further than one column and also look for the value that I provide in Column 1, 2 and 3.

My question is can that be done in the same statement ? If so how ?

Column 1 | Column 2 | Column 3
R01 Prim IP-Eth0 | R01 Prim IP-Eth0 | R01 Sec IP-Eth0

 

[PHV]

In the sql pane:
SELECT ...
WHERE ([Column 1] & [Column 2] & [Column 3] Like '*' & [What is the IP?] & "*") ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[PHV]

Oops, hit submit instead of preview ...
WHERE ([Column 1] & "," & [Column 2] & "," & [Column 3] Like '*' & [What is the IP?] & "*")

Another way:
WHERE ([Column 1] Like '*' & [What is the IP?] & "*"
OR [Column 2] Like '*' & [What is the IP?] & "*"
OR [Column 3] Like '*' & [What is the IP?] & "*")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[lespaul]

A more long term solution is to normalize your database structure - Fundamentals of Relational Database Design

Leslie

 

[r937]

for those of you who would prefer to read that article on a web page instead of a microsoft word document, use this link instead --

Fundamentals of Relational Database Design



rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts March 6 2005)

 

[007700]

Thanks PH,

That did the trick for me...... The solution I was looking into was far to difficult, and this gave me the same results..

Thanks