searching through results

[Joey Martin]

I know how to use the LIKE command in a query but how do I do it in the
results of a recordset?

results="<b>Hello</b> World"

I want to search the above result and if it has a <B> in it, I want set
hasabold="Y"
I need to be able to search through a large amount of text so the BOLD marks
will not always be at the front of the results. They maybe be on line 50
character 59, etc....

 

[Aaron Bertrand - MVP]

Why don't you do it from the query?

It helps if you tell us which database you're using (see
http://www.aspfaq.com/5009), but for SQL Server:

SELECT hasabold = CASE WHEN CHARINDEX('<b>', column)>0 THEN 'Y' ELSE 'N'
END,
<otherstuff> FROM table

 

[Joey Martin]

Let me be more clear so as not to be confusing.

I am actually importing a text file. I am reading the lines and they are
goin into "sections".
For example section A may read: This is a test and it has a bold <b>
right</b> here.

It typically includes 10-20 lines of text.
I just need to look through that Section A and if it has a bold, mark it as
such use sectionabold=Y

 

[Aaron Bertrand - MVP]

So, look at the INSTR() function of VBScript...

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

 

[Joey Martin]

Perfect. Thanks!

So, look at the INSTR() function of VBScript...

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




line