Query - check for a string in stored procedure

Hi,

I would like to check if a string value exist in a string in sql
server stored procedure, e.g.

set @.testString = 'this is my test document.'
if (@.testString contains 'test')
begin
....
end

How do I do this in sql server stored procedure?

Thanks,
June...try this

Declare @.testString varchar(100)
set @.testString = 'this is my test document.'
if charindex('test',@.testString)>0

begin
....
end

Madhivanan

ql 2005 INSTAL Doc

Any one know where I can find a good SQL 2005 install Document?
Thanks,
OmranI'm not too sure what you are asking for, but perhaps these will help you.
SQL Server 2005 Installation Requirements (Hardware/Software)
http://msdn2.microsoft.com/en-us/library/ms143506.aspx
SQL Server 2005 Readme and installation requirements
http://support.microsoft.com/kb/910228/en-us
SQL Server 2005 Upgrade Advisor
http://www.microsoft.com/downloads/details.aspx?familyid=1470E86B-7E05-4322-A677-95AB44F12D75&displaylang=en
SQL Server 2005 Upgrade Technical Reference Guide
http://www.microsoft.com/downloads/details.aspx?familyid=3D5E96D9-0074-46C4-BD4F-3EB2ABF4B66&displaylang=en
SQL Server -UpGrade SQL 2000 to SQL 2005
http://www.microsoft.com/technet/prodtechnol/sql/themes/upgrade.mspx
http://msdn2.microsoft.com/en-us/library/ms199026.aspx
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Omran Abdurrahman" <omranab@.comcast.net> wrote in message
news:O9JBN7v%23GHA.3344@.TK2MSFTNGP03.phx.gbl...
> Any one know where I can find a good SQL 2005 install Document?
> Thanks,
> Omran
>

q: word document

Hello,
Is it possible to show a word document coming from database in a sub-report?Hello,
i have the same question. Is it possible to show a word document (from a
Database OLE-Object(BLOB-Field)?!
How do i make that?!
Best reagards
Daniel
"JIM.H." wrote:
> Hello,
> Is it possible to show a word document coming from database in a sub-report?
>|||is it possible or not?! Could someone give me an answer please?!
"Daniel Doerfel" wrote:
> Hello,
> i have the same question. Is it possible to show a word document (from a
> Database OLE-Object(BLOB-Field)?!
> How do i make that?!
> Best reagards
> Daniel
> "JIM.H." wrote:
> > Hello,
> > Is it possible to show a word document coming from database in a sub-report?
> >
> >