September 23, 2003 at 7:36 am
Might try something like:
declare @test-2 as varchar(25)
set @test-2 = 'sys'
set @test-2 = '%' + @test-2 + '%'
SELECT * from sysobjects where name like @test-2
-- or
set @test-2 = 'sys'
SELECT * from sysobjects where name like '%' + @test-2 + '%'
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
September 23, 2003 at 7:41 am
Thanks a lot Greg... Praveen
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply