concat fields then search the new field

[Darren Heinrich]

how would I concatenate several fields from a record set then search the new
field for individual keywords ?

something like:

Dim theArray

for i = 1 to recSet.RecordCount
theArray(i) = recSet("field1) & recSet("field2') etc
next

But then what statements would i use to search it ?

Darren

[Aaron Bertrand [MVP]]

Why do you want to bring the data back to the ASP page and then search it
there? I think it would be more efficient to search the database at the
database...

--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]




"Darren Heinrich" <dazzjazz@ozemail.com.au> wrote in message
news:cTEUb.189$J9.3209@nnrp1.ozemail.com.au...

> how would I concatenate several fields from a record set then search the

new

> field for individual keywords ?
>
> something like:
>
> Dim theArray
>
> for i = 1 to recSet.RecordCount
> theArray(i) = recSet("field1) & recSet("field2') etc
> next
>
> But then what statements would i use to search it ?
>
> Darren
>
>
>
>

[Darren Heinrich]

I don't know - sorry I'm a part timer !!!
Should I be making a temp table or something ?

Darren


"Aaron Bertrand [MVP]" <aaron@TRASHaspfaq.com> wrote in message
news:OttzmVH7DHA.3008@TK2MSFTNGP09.phx.gbl...

> Why do you want to bring the data back to the ASP page and then search it
> there? I think it would be more efficient to search the database at the
> database...
>
> --
> Aaron Bertrand
> SQL Server MVP
> [url]http://www.aspfaq.com/[/url]
>
>
>
>
> "Darren Heinrich" <dazzjazz@ozemail.com.au> wrote in message
> news:cTEUb.189$J9.3209@nnrp1.ozemail.com.au...

> > how would I concatenate several fields from a record set then search the

> new

> > field for individual keywords ?
> >
> > something like:
> >
> > Dim theArray
> >
> > for i = 1 to recSet.RecordCount
> > theArray(i) = recSet("field1) & recSet("field2') etc
> > next
> >
> > But then what statements would i use to search it ?
> >
> > Darren
> >
> >
> >
> >

>
>

[Bob Barrows]

Darren Heinrich wrote:

> how would I concatenate several fields from a record set then search
> the new field for individual keywords ?
>
> something like:
>
> Dim theArray
>
> for i = 1 to recSet.RecordCount
> theArray(i) = recSet("field1) & recSet("field2') etc
> next
>

No, don't do that. Let the database do it:

Select ...
WHERE [field1] & [field2] LIKE "%searchword%"

HTH,
Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[Aaron Bertrand - MVP]

> Should I be making a temp table or something ?

What would a temp table do for you? SEARCH THE TABLE. You seem to be going
out of your way, in all of your posts, to re-invent the wheel.

--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]