create function dbo.substr(@s varchar( 100 ), @p1 int, @p2 int)
returns varchar( 100 )
as begin
 return substring(@s, @p1, @p2-@p1)
end
go
declare @s varchar ( 100 )
set @s = 'fdsag X3 fdrewq'
select dbo.substr(@s, patindex('%X[0-9]%', @s), charindex(' ', @s, patindex('%X[0-9]%', @s)))
go
drop function dbo.substr

declare @symb varchar( 100 ), @p1 int, @s varchar( 100 )
select @s = 'asdf Х56 rewq'
set @Symb='[NХ№]'
set @p1=patindex('% '+@Symb+'[0-9]%',@s)
select @p1

declare @t table (id int identity( 1 , 1 ), src varchar( 100 ), dest varchar( 100 ), type tinyint)
insert into @t values ('таб.','таблица',  1 )
insert into @t values ('табл.','таблица',  1 )

declare @s varchar( 100 )
set @s = 'моя табл. не моя таб.'
 --2 
select *, charindex(src, @s) from @t where type =  1  and charindex(src, @s)=(select min(isnull(charindex(src, @s), 0 )) from @t where charindex(src, @s)> 0  and type =  1 )
 --1 
select @s = replace(@s, src, dest) from @t where type =  1 
select @s

alter FUNCTION dbo.fn_ReplaceTrash(@Where char( 255 ), @type varchar( 100 ) = null)
returns char( 255 )
AS
BEGIN
select @Where=Replace(@Where,Was,Will) from TrashSymb where type = isnull(@type,type)
Return (@Where)
END

create table TrashSymb (Was Char( 10 ), Will Char( 10 ), type varchar( 100 ) default '')
INSERT INTO TrashSymb VALUES ('(*)','')
INSERT INTO TrashSymb VALUES ('@','')
create table dictp (sname varchar( 100 ), mname varchar( 100 ))
insert into dictp values('fdsajklrew @ fdreui (*) fdsre ((*)) fdsrew ','')

update DictP
set Mname=dbo.fn_ReplaceTrash(Sname)
select Top  10  * from DictP

INSERT INTO TrashSymb VALUES ('((*))','')

select @Where=Replace(@Where,Was,Will) from TrashSymb where type = isnull(@type,type) order by ord

Create Function dbo.fn_Cup2Dot (@S varchar( 255 ))
returns varchar( 255 )
as Begin
 declare @p1 int
 declare @Symb varchar( 1 )
 declare @retu varchar( 255 )
 set @retu = @s
 set @Symb=','
 set @p1=patindex('%[0-9]'+@Symb+'[0-9]%',@retu)
 if @p1> 0  begin
  While dbo.fn_Cup2Dot (@retu)<>@retu begin
   set @retu= substring(@retu, 0 , @p1+ 1 )+'.'+substring(@retu,@p1+ 2 , Len(@retu)-@p1+ 3 )
   set @p1=patindex('%[0-9]'+@Symb+'[0-9]%',@retu,@p1+ 1 )
  end 
 end else begin
  set @retu=@S
 end
 Return @Retu
End

Create Function dbo.fn_Cup2Dot (@S varchar( 255 ))
returns varchar( 255 )
as Begin
 declare @p1 int
 declare @Symb varchar( 1 )
 declare @retu varchar( 255 )
 set @retu = @s
 set @Symb=','
 set @p1=patindex('%[0-9]'+@Symb+'[0-9]%',@retu)
 while @p1> 0  begin
  set @retu= substring(@retu, 0 , @p1+ 1 )+'.'+substring(@retu,@p1+ 2 , Len(@retu)-@p1+ 3 )
  set @p1=patindex('%[0-9]'+@Symb+'[0-9]%',@retu,@p1+ 1 )
 end
 Return @Retu
End