| | |
| | |
Terms of Agreement:
By using this article, you agree to the following terms...
1) You may use
this article in your own programs (and may compile it into a program and distribute it in compiled format for langauges that allow it) freely and with no charge.
2) You MAY NOT redistribute this article (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.
3) You may link to this article from another website, but ONLY if it is not wrapped in a frame.
4) You will abide by any additional copyright restrictions which the author may have placed in the article or article's description. | | For a long time i used this sort of querys "select * from Data where instr(1,Field1,'Search'),instr(1,Field2,'Search')". Until i tried this one- "select * from Data where instr(1,Field1 & Field2,'Search'). Hope somebody will find some use for it. | |
Other 1 submission(s) by this author
| | | | | Report Bad Submission | | | | | Your Vote! | |
See Voting Log | | | | Other User Comments | 1/12/2001 11:59:47 AM:Markito
Are you sure this works on SQL??
| 1/15/2001 2:16:19 AM:Fernando Pires
It works on sql in access
| 1/15/2001 2:19:13 AM:Fernando Pires
If it does not work,you can use
contains whith multiple fields.
| 7/7/2001 2:51:53 AM:Youpeta
Hi, you could try this for SQL:
select
Field1, Field2 from tblpat where
CHARINDEX('search string',Field1 +
Field2 , 1) >0
Or
select Field1,
Field2 from tblpat where Field 1 like
'%search string%' or Field 2 like
'%search string%'
I guess they should
return the same results. I tried both,
but don't know if there's a
speed-difference because of caching or
because the second query is
faster.
Query1: 1:38 min
Query2: 18
sec
| 7/7/2001 3:08:43 AM:youpeta
OOPS,
Query1: select Field1, Field2
from tblpat where CHARINDEX('search
string',Field1 + Field2 , 1) >0
Query2: select Field1, Field2 from
tblpat where Field 1 like '%search
string%' or Field 2 like '%search
string%'
This should also work for
access, but you'll probably have to use
another wildchar like *
| | | Add Your Feedback! | Note:Not only will your feedback be posted, but an email will be sent to the code's author in your name.
NOTICE: The author of this article has been kind enough to share it with you. If you have a criticism, please state it politely or it will be deleted.
For feedback not related to this particular article, please click here.
| |
|
