Sybase 문자 함수

 

문자치환

declare @STR1 varchar(100), @STR2  varchar(100), @STR3 varchar(100)
set @STR1 = '가나다라마바사아 인간은 8020가나다라'
set @STR2 = '8020'
set @STR3 = '8010'

select @STR1

select str_replace(@STR1,@STR2,@STR3)

복잡하게 하면

 

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15.0.blocks/html/blocks/blocks213.htm

 

 

select substring(@STR1, 1, charindex(@STR2 ,@STR1) -1) + @STR3
+ substring(@STR1, charindex(@STR2 ,@STR1) + datalength(@STR2), datalength(@STR1))

 

 

특정 문자 근처를 출력

declare @STR1 varchar(100), @KEYWORD  varchar(100)
set @STR1 = '가나다라마바사아 인간은 가나다라'
set @KEYWORD = '인간'
select substring(@STR1, charindex(@KEYWORD ,@STR1) - 3, datalength(@KEYWORD) + 3 )

 

문자반복

SELECT REPLICATE('0', 3 - DATALENGTH(c1)) + c1 AS [Varchar Column], REPLICATE('0', 3 - DATALENGTH(c2)) + c2 AS [Char Column] FROM t1