Search results for query: *

How would I substitute the '%and%' with a variable like: declare @PWORD varchar(10) set @PWORD='and' select title_id, substring(notes, (PATINDEX('% @PWORD %', notes)-25), (PATINDEX('% @PWORD %', notes)+24)) FROM titles where PATINDEX('% @PWORD %', notes)>0

I apologize, I think I was trying to make it harder on myself then I had to, this is great. Thanks

Real rough... I've never had any issues except maybe with performance. I try to warehouse transactions after given time frame so my transaction table stays under 1,000,000 records. Even at that size I get very little performance hits. My archive table now is split in 2, the larger ones has...

No, I must have not been clear enough. select statement 1 finds 10+- rows, I need to iterate through select statment #2 10+- times.

In 2000 and 2002 you have to have programming help loaded else you can't get help for programming issues. AllowBypassKey can onlt be manipulated via vba.

Using pubs as an example - Considering the batch below, how would I loop through the 2nd select statement for the number of rows that are selected in the first select statement? Current of course it returns only the last string. The point of this is to return a short string from each of the...

Did you ever get an answer on this? I also need to validate an email addredd with T-SQL

What I do in these cases, where I want the user to create their own queries, is to build a metadata table that includes the statements for the partucular query. You can make it as easy on yourself as you wish, when the user clicks a button, they get a result. Or you can allow them to select...