declare @s varchar(200)
--set @s = 'rock'
--set @s = 'rock_my_world'
--set @s = 'mp3'
--set @s = 'mymusic'
--set @s = 'rock_my_world.mp3'
set @s = '/home/media/mymusic/rock_my_world.mp3'

select d.*
from   (
       select [Path] = '/home/media/mymusic'
              ,[filename] = 'rock_my_world'
              ,extension = 'mp3'
       ) d
where charindex(@s, [Path] + '/' + [filename] + '.' + extension) > 0

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MatchText]') and xtype in (N'FN', N'IF', N'TF'))
drop function [dbo].[MatchText]
GO

CREATE function MatchText (@InputString varchar (50))
returns varchar (50)

begin
-- blindman, 7/2005

-- --test parameters
-- declare	@InputString varchar(50)
-- set	@InputString = 'Bruce a. Lindman'

declare @TempString varchar (50)
declare @OutputString varchar (50)
declare @CharNum integer
declare @TestChar CHAR(1)

--Convert to uppercase and remove noise characters
set @TempString = UPPER(@InputString)
set @TempString = replace(@TempString, 'A', '')
set @TempString = replace(@TempString, 'E', '')
set @TempString = replace(@TempString, 'I', '')
set @TempString = replace(@TempString, 'O', '')
set @TempString = replace(@TempString, 'U', '')

--Build @OutputString with only alphanumeric characters
set @CharNum = 1
set @OutputString = ''
while @CharNum <= len(@TempString)
	begin
		set @TestChar = substring(@TempString, @CharNum, 1)
		if (@TestChar between 'A' and 'Z') OR (@TestChar between '0' and '9') set @OutputString = @OutputString + @TestChar
		set @CharNum = @CharNum + 1
	end

return @OutputString
end
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CompareText]') and xtype in (N'FN', N'IF', N'TF'))
drop function [dbo].[CompareText]
GO