Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 question..if exists....

Author  Topic 

xpandre
Posting Yak Master

212 Posts

Posted - 2003-11-17 : 05:04:56
Hi,

if exists(select 1 from testgood where names like %@charr% and names not like @thetext)

how do i use this...i have to use a variable (@charr) in the query.

thank you

rksingh024
Yak Posting Veteran

56 Posts

Posted - 2003-11-17 : 05:25:13
if exists(select 1 from testgood where names like '%' + @charr + '%' and names not like @thetext)


Ramesh Singh
Go to Top of Page

xpandre
Posting Yak Master

212 Posts

Posted - 2003-11-17 : 06:12:27
thank you
Go to Top of Page
   

- Advertisement -