I mean how are is it to prevalidate the data?  You know the datatype and you know the lengh (or range of value) of the target table.

Len(ColName) will validate the...

Without reading that article, I have a situation here where a bit column is very indexable since this flag is on for about 25 to 125 rows out of 30...

Depending on the cost of the query, maybe you can do this in a stored proc :

DECLARE @OutputColumns AS VARCHAR(1000) OUTPUT

CREATE TABLE #temp

Insert into #temp

YourQueryHere

Then scan the resultSet

I'm not...

1 - HTML is used to format and display the data so it's common to all database systems.  What you normally see with sql server is ASP, ASP.NET and C#.net. ...

I c said the blind woman .

It's not unsupported for no reason (unless it changed in 2005).

Care to extend your comments on this one ?

"views generally don't perform very well anyway"

Maybe but I still don't get his idea.

I can manually replace the occurance of "<" to ">" to something else but I need to know how to do it faster. ...

The forum will benefit much more from 2 prolific posters with 2 very different work experience than just one zelus poster.

Thanx for the help!

NP.

So when are you scheduled for that public humiliation session?

This article may be of particular interest to you :

http://www.sommarskog.se/dyn-search.html

1 - Can more than one parameter be search at the same time, if yes what is the limit?

2 - How many parameters are passed to this procedure?

3 - Which...

I have no idea of what you are trying to say... can you show a working example with this data?

DECLARE @x AS VARCHAR(8000)

SET @x = '  <table>test3<font>sometext</font>tex2</table>'

SELECT PATINDEX ('<[^<>]*>', @x)

That could make sens.... but then again, I ain't receiving any birthday letter from any gouvernemental agency so I guess it may be for some other reason

What's missing in that analysis?