Sqlite에서의 Replace문.

문자열 Replace시 사용.

replace(X,Y,Z)

The replace(X,Y,Z) function returns a string formed by substituting string Z for every occurrence of string Y in string X. The BINARY collating sequence is used for comparisons. If Y is an empty string then return X unchanged. If Z is not initially a string, it is cast to a UTF-8 string prior to processing.

출처 >  http://www.sqlite.org/lang_corefunc.html#replace


사용예 > 

SELECT REPLACE(CountryName, "K", "L") FROM Country ;