SQLで文字列の全角と半角を変換（置換）する [SQLServer]

SQLServerには半角文字を全角文字に変換したり、全角文字を半角に変換してくれる関数がありません。

そこで、SQLで全角を半角に変換、半角を全角に変換するクエリを作成しました。
SQLServerではCLR関数を作成することで、Visual Basic（またはC#）でStrConv関数を使用して変換する処理を実装し、コンパイルして作成したdllを使って実現することもできますが、ここではSQLのみで変換するために、1文字ずつREPLACE関数で処理を行っています。

全角から半角へ変換

-- 変換する文字列
DECLARE @string nvarchar(4000);
SET @string = N'ａｂｃｄｅｆｇｈｉｊｋｌｍｎｏｐｑｒｓｔｕｖｗｘｙｚＡＢＣＤＥＦＧＨＩＪＫＬＭＮＯＰＱＲＳＴＵＶＷＸＹＺ！”“＃＄％＆’（）ー－＝＾～￥｜‘「［｛＋；＊：」］｝、，＜。．＞／・？＿×÷　〈【『〔≪《〉】』〕≫》ヴガギグゲゴザジズゼゾダヂヅデドバビブベボパピプペポアイウエオカキクケコサシスセソタチツテトナニヌネノハヒフヘホマミムメモヤユヨラリルレロワヲンァィゥェォッャュョヶヵ０１２３４５６７８９';

/* 小文字アルファベット */
SET @string = REPLACE(@string, 'ａ', 'a');
SET @string = REPLACE(@string, 'ｂ', 'b');
SET @string = REPLACE(@string, 'ｃ', 'c');
SET @string = REPLACE(@string, 'ｄ', 'd');
SET @string = REPLACE(@string, 'ｅ', 'e');
SET @string = REPLACE(@string, 'ｆ', 'f');
SET @string = REPLACE(@string, 'ｇ', 'g');
SET @string = REPLACE(@string, 'ｈ', 'h');
SET @string = REPLACE(@string, 'ｉ', 'i');
SET @string = REPLACE(@string, 'ｊ', 'j');
SET @string = REPLACE(@string, 'ｋ', 'k');
SET @string = REPLACE(@string, 'ｌ', 'l');
SET @string = REPLACE(@string, 'ｍ', 'm');
SET @string = REPLACE(@string, 'ｎ', 'n');
SET @string = REPLACE(@string, 'ｏ', 'o');
SET @string = REPLACE(@string, 'ｐ', 'p');
SET @string = REPLACE(@string, 'ｑ', 'q');
SET @string = REPLACE(@string, 'ｒ', 'r');
SET @string = REPLACE(@string, 'ｓ', 's');
SET @string = REPLACE(@string, 'ｔ', 't');
SET @string = REPLACE(@string, 'ｕ', 'u');
SET @string = REPLACE(@string, 'ｖ', 'v');
SET @string = REPLACE(@string, 'ｗ', 'w');
SET @string = REPLACE(@string, 'ｘ', 'x');
SET @string = REPLACE(@string, 'ｙ', 'y');
SET @string = REPLACE(@string, 'ｚ', 'z');
/* 大文字アルファベット */
SET @string = REPLACE(@string, 'Ａ', 'A');
SET @string = REPLACE(@string, 'Ｂ', 'B');
SET @string = REPLACE(@string, 'Ｃ', 'C');
SET @string = REPLACE(@string, 'Ｄ', 'D');
SET @string = REPLACE(@string, 'Ｅ', 'E');
SET @string = REPLACE(@string, 'Ｆ', 'F');
SET @string = REPLACE(@string, 'Ｇ', 'G');
SET @string = REPLACE(@string, 'Ｈ', 'H');
SET @string = REPLACE(@string, 'Ｉ', 'I');
SET @string = REPLACE(@string, 'Ｊ', 'J');
SET @string = REPLACE(@string, 'Ｋ', 'K');
SET @string = REPLACE(@string, 'Ｌ', 'L');
SET @string = REPLACE(@string, 'Ｍ', 'M');
SET @string = REPLACE(@string, 'Ｎ', 'N');
SET @string = REPLACE(@string, 'Ｏ', 'O');
SET @string = REPLACE(@string, 'Ｐ', 'P');
SET @string = REPLACE(@string, 'Ｑ', 'Q');
SET @string = REPLACE(@string, 'Ｒ', 'R');
SET @string = REPLACE(@string, 'Ｓ', 'S');
SET @string = REPLACE(@string, 'Ｔ', 'T');
SET @string = REPLACE(@string, 'Ｕ', 'U');
SET @string = REPLACE(@string, 'Ｖ', 'V');
SET @string = REPLACE(@string, 'Ｗ', 'W');
SET @string = REPLACE(@string, 'Ｘ', 'X');
SET @string = REPLACE(@string, 'Ｙ', 'Y');
SET @string = REPLACE(@string, 'Ｚ', 'Z');
/* 記号など */
SET @string = REPLACE(@string, '！', '!');
SET @string = REPLACE(@string, '”', '"');
SET @string = REPLACE(@string, '“', '"');
SET @string = REPLACE(@string, '＃', '#');
SET @string = REPLACE(@string, '＄', '$');
SET @string = REPLACE(@string, '％', '%');
SET @string = REPLACE(@string, '＆', '&');
SET @string = REPLACE(@string, '’', '''');
SET @string = REPLACE(@string, '（', '(');
SET @string = REPLACE(@string, '）', ')');
SET @string = REPLACE(@string, 'ー', 'ｰ');
SET @string = REPLACE(@string, '－', '-');
SET @string = REPLACE(@string, '＝', '=');
SET @string = REPLACE(@string, '＾', '^');
SET @string = REPLACE(@string, '～', '~');
SET @string = REPLACE(@string, '￥', '\');
SET @string = REPLACE(@string, '｜', '|');
SET @string = REPLACE(@string, '‘', '`');
SET @string = REPLACE(@string, '「', '[');
SET @string = REPLACE(@string, '［', '[');
SET @string = REPLACE(@string, '｛', '{');
SET @string = REPLACE(@string, '＋', '+');
SET @string = REPLACE(@string, '；', ';');
SET @string = REPLACE(@string, '＊', '*');
SET @string = REPLACE(@string, '：', ':');
SET @string = REPLACE(@string, '」', ']');
SET @string = REPLACE(@string, '］', ']');
SET @string = REPLACE(@string, '｝', '}');
SET @string = REPLACE(@string, '、', ',');
SET @string = REPLACE(@string, '，', ',');
SET @string = REPLACE(@string, '＜', '<');
SET @string = REPLACE(@string, '。', '.');
SET @string = REPLACE(@string, '．', '.');
SET @string = REPLACE(@string, '＞', '>');
SET @string = REPLACE(@string, '／', '/');
SET @string = REPLACE(@string, '・', '/');
SET @string = REPLACE(@string, '？', '?');
SET @string = REPLACE(@string, '＿', '_');
SET @string = REPLACE(@string, '×', '*');
SET @string = REPLACE(@string, '÷', '/');
SET @string = REPLACE(@string, '　', ' ');
SET @string = REPLACE(@string, '〈', '(');
SET @string = REPLACE(@string, '【', '[');
SET @string = REPLACE(@string, '『', '[');
SET @string = REPLACE(@string, '〔', '[');
SET @string = REPLACE(@string, '≪', '<<');
SET @string = REPLACE(@string, '《', '((');
SET @string = REPLACE(@string, '〉', ')');
SET @string = REPLACE(@string, '】', ']');
SET @string = REPLACE(@string, '』', ']');
SET @string = REPLACE(@string, '〕', ']');
SET @string = REPLACE(@string, '≫', '>>');
SET @string = REPLACE(@string, '》', '))');
/* カタカナ */
-- 濁音、半濁音（半角2文字へ変換）
SET @string = REPLACE(@string, 'ヴ', 'ｳﾞ');
SET @string = REPLACE(@string, 'ガ', 'ｶﾞ');
SET @string = REPLACE(@string, 'ギ', 'ｷﾞ');
SET @string = REPLACE(@string, 'グ', 'ｸﾞ');
SET @string = REPLACE(@string, 'ゲ', 'ｹﾞ');
SET @string = REPLACE(@string, 'ゴ', 'ｺﾞ');
SET @string = REPLACE(@string, 'ザ', 'ｻﾞ');
SET @string = REPLACE(@string, 'ジ', 'ｼﾞ');
SET @string = REPLACE(@string, 'ズ', 'ｽﾞ');
SET @string = REPLACE(@string, 'ゼ', 'ｾﾞ');
SET @string = REPLACE(@string, 'ゾ', 'ｿﾞ');
SET @string = REPLACE(@string, 'ダ', 'ﾀﾞ');
SET @string = REPLACE(@string, 'ヂ', 'ﾁﾞ');
SET @string = REPLACE(@string, 'ヅ', 'ﾂﾞ');
SET @string = REPLACE(@string, 'デ', 'ﾃﾞ');
SET @string = REPLACE(@string, 'ド', 'ﾄﾞ');
SET @string = REPLACE(@string, 'バ', 'ﾊﾞ');
SET @string = REPLACE(@string, 'ビ', 'ﾋﾞ');
SET @string = REPLACE(@string, 'ブ', 'ﾌﾞ');
SET @string = REPLACE(@string, 'ベ', 'ﾍﾞ');
SET @string = REPLACE(@string, 'ボ', 'ﾎﾞ');
SET @string = REPLACE(@string, 'パ', 'ﾊﾟ');
SET @string = REPLACE(@string, 'ピ', 'ﾋﾟ');
SET @string = REPLACE(@string, 'プ', 'ﾌﾟ');
SET @string = REPLACE(@string, 'ペ', 'ﾍﾟ');
SET @string = REPLACE(@string, 'ポ', 'ﾎﾟ');
-- 通常
SET @string = REPLACE(@string, 'ア', 'ｱ');
SET @string = REPLACE(@string, 'イ', 'ｲ');
SET @string = REPLACE(@string, 'ウ', 'ｳ');
SET @string = REPLACE(@string, 'エ', 'ｴ');
SET @string = REPLACE(@string, 'オ', 'ｵ');
SET @string = REPLACE(@string, 'カ', 'ｶ');
SET @string = REPLACE(@string, 'キ', 'ｷ');
SET @string = REPLACE(@string, 'ク', 'ｸ');
SET @string = REPLACE(@string, 'ケ', 'ｹ');
SET @string = REPLACE(@string, 'コ', 'ｺ');
SET @string = REPLACE(@string, 'サ', 'ｻ');
SET @string = REPLACE(@string, 'シ', 'ｼ');
SET @string = REPLACE(@string, 'ス', 'ｽ');
SET @string = REPLACE(@string, 'セ', 'ｾ');
SET @string = REPLACE(@string, 'ソ', 'ｿ');
SET @string = REPLACE(@string, 'タ', 'ﾀ');
SET @string = REPLACE(@string, 'チ', 'ﾁ');
SET @string = REPLACE(@string, 'ツ', 'ﾂ');
SET @string = REPLACE(@string, 'テ', 'ﾃ');
SET @string = REPLACE(@string, 'ト', 'ﾄ');
SET @string = REPLACE(@string, 'ナ', 'ﾅ');
SET @string = REPLACE(@string, 'ニ', 'ﾆ');
SET @string = REPLACE(@string, 'ヌ', 'ﾇ');
SET @string = REPLACE(@string, 'ネ', 'ﾈ');
SET @string = REPLACE(@string, 'ノ', 'ﾉ');
SET @string = REPLACE(@string, 'ハ', 'ﾊ');
SET @string = REPLACE(@string, 'ヒ', 'ﾋ');
SET @string = REPLACE(@string, 'フ', 'ﾌ');
SET @string = REPLACE(@string, 'ヘ', 'ﾍ');
SET @string = REPLACE(@string, 'ホ', 'ﾎ');
SET @string = REPLACE(@string, 'マ', 'ﾏ');
SET @string = REPLACE(@string, 'ミ', 'ﾐ');
SET @string = REPLACE(@string, 'ム', 'ﾑ');
SET @string = REPLACE(@string, 'メ', 'ﾒ');
SET @string = REPLACE(@string, 'モ', 'ﾓ');
SET @string = REPLACE(@string, 'ヤ', 'ﾔ');
SET @string = REPLACE(@string, 'ユ', 'ﾕ');
SET @string = REPLACE(@string, 'ヨ', 'ﾖ');
SET @string = REPLACE(@string, 'ラ', 'ﾗ');
SET @string = REPLACE(@string, 'リ', 'ﾘ');
SET @string = REPLACE(@string, 'ル', 'ﾙ');
SET @string = REPLACE(@string, 'レ', 'ﾚ');
SET @string = REPLACE(@string, 'ロ', 'ﾛ');
SET @string = REPLACE(@string, 'ワ', 'ﾜ');
SET @string = REPLACE(@string, 'ヲ', 'ｦ');
SET @string = REPLACE(@string, 'ン', 'ﾝ');
-- 小文字
SET @string = REPLACE(@string, 'ァ', 'ｧ');
SET @string = REPLACE(@string, 'ィ', 'ｨ');
SET @string = REPLACE(@string, 'ゥ', 'ｩ');
SET @string = REPLACE(@string, 'ェ', 'ｪ');
SET @string = REPLACE(@string, 'ォ', 'ｫ');
SET @string = REPLACE(@string, 'ッ', 'ｯ');
SET @string = REPLACE(@string, 'ャ', 'ｬ');
SET @string = REPLACE(@string, 'ュ', 'ｭ');
SET @string = REPLACE(@string, 'ョ', 'ｮ');
SET @string = REPLACE(@string, 'ヶ', 'ｹ');
SET @string = REPLACE(@string, 'ヵ', 'ｶ');
/* 数字 */
SET @string = REPLACE(@string, '０', '0');
SET @string = REPLACE(@string, '１', '1');
SET @string = REPLACE(@string, '２', '2');
SET @string = REPLACE(@string, '３', '3');
SET @string = REPLACE(@string, '４', '4');
SET @string = REPLACE(@string, '５', '5');
SET @string = REPLACE(@string, '６', '6');
SET @string = REPLACE(@string, '７', '7');
SET @string = REPLACE(@string, '８', '8');
SET @string = REPLACE(@string, '９', '9');

SELECT @string;

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

-- 変換する文字列

DECLARE @string nvarchar(4000);

SET @string = N'ａｂｃｄｅｆｇｈｉｊｋｌｍｎｏｐｑｒｓｔｕｖｗｘｙｚＡＢＣＤＥＦＧＨＩＪＫＬＭＮＯＰＱＲＳＴＵＶＷＸＹＺ！”“＃＄％＆’（）ー－＝＾～￥｜‘「［｛＋；＊：」］｝、，＜。．＞／・？＿×÷　〈【『〔≪《〉】』〕≫》ヴガギグゲゴザジズゼゾダヂヅデドバビブベボパピプペポアイウエオカキクケコサシスセソタチツテトナニヌネノハヒフヘホマミムメモヤユヨラリルレロワヲンァィゥェォッャュョヶヵ０１２３４５６７８９';

/* 小文字アルファベット */

SET @string = REPLACE(@string, 'ａ', 'a');

SET @string = REPLACE(@string, 'ｂ', 'b');

SET @string = REPLACE(@string, 'ｃ', 'c');

SET @string = REPLACE(@string, 'ｄ', 'd');

SET @string = REPLACE(@string, 'ｅ', 'e');

SET @string = REPLACE(@string, 'ｆ', 'f');

SET @string = REPLACE(@string, 'ｇ', 'g');

SET @string = REPLACE(@string, 'ｈ', 'h');

SET @string = REPLACE(@string, 'ｉ', 'i');

SET @string = REPLACE(@string, 'ｊ', 'j');

SET @string = REPLACE(@string, 'ｋ', 'k');

SET @string = REPLACE(@string, 'ｌ', 'l');

SET @string = REPLACE(@string, 'ｍ', 'm');

SET @string = REPLACE(@string, 'ｎ', 'n');

SET @string = REPLACE(@string, 'ｏ', 'o');

SET @string = REPLACE(@string, 'ｐ', 'p');

SET @string = REPLACE(@string, 'ｑ', 'q');

SET @string = REPLACE(@string, 'ｒ', 'r');

SET @string = REPLACE(@string, 'ｓ', 's');

SET @string = REPLACE(@string, 'ｔ', 't');

SET @string = REPLACE(@string, 'ｕ', 'u');

SET @string = REPLACE(@string, 'ｖ', 'v');

SET @string = REPLACE(@string, 'ｗ', 'w');

SET @string = REPLACE(@string, 'ｘ', 'x');

SET @string = REPLACE(@string, 'ｙ', 'y');

SET @string = REPLACE(@string, 'ｚ', 'z');

/* 大文字アルファベット */

SET @string = REPLACE(@string, 'Ａ', 'A');

SET @string = REPLACE(@string, 'Ｂ', 'B');

SET @string = REPLACE(@string, 'Ｃ', 'C');

SET @string = REPLACE(@string, 'Ｄ', 'D');

SET @string = REPLACE(@string, 'Ｅ', 'E');

SET @string = REPLACE(@string, 'Ｆ', 'F');

SET @string = REPLACE(@string, 'Ｇ', 'G');

SET @string = REPLACE(@string, 'Ｈ', 'H');

SET @string = REPLACE(@string, 'Ｉ', 'I');

SET @string = REPLACE(@string, 'Ｊ', 'J');

SET @string = REPLACE(@string, 'Ｋ', 'K');

SET @string = REPLACE(@string, 'Ｌ', 'L');

SET @string = REPLACE(@string, 'Ｍ', 'M');

SET @string = REPLACE(@string, 'Ｎ', 'N');

SET @string = REPLACE(@string, 'Ｏ', 'O');

SET @string = REPLACE(@string, 'Ｐ', 'P');

SET @string = REPLACE(@string, 'Ｑ', 'Q');

SET @string = REPLACE(@string, 'Ｒ', 'R');

SET @string = REPLACE(@string, 'Ｓ', 'S');

SET @string = REPLACE(@string, 'Ｔ', 'T');

SET @string = REPLACE(@string, 'Ｕ', 'U');

SET @string = REPLACE(@string, 'Ｖ', 'V');

SET @string = REPLACE(@string, 'Ｗ', 'W');

SET @string = REPLACE(@string, 'Ｘ', 'X');

SET @string = REPLACE(@string, 'Ｙ', 'Y');

SET @string = REPLACE(@string, 'Ｚ', 'Z');

/* 記号など */

SET @string = REPLACE(@string, '！', '!');

SET @string = REPLACE(@string, '”', '"');

SET @string = REPLACE(@string, '“', '"');

SET @string = REPLACE(@string, '＃', '#');

SET @string = REPLACE(@string, '＄', '$');

SET @string = REPLACE(@string, '％', '%');

SET @string = REPLACE(@string, '＆', '&');

SET @string = REPLACE(@string, '’', '''');

SET @string = REPLACE(@string, '（', '(');

SET @string = REPLACE(@string, '）', ')');

SET @string = REPLACE(@string, 'ー', 'ｰ');

SET @string = REPLACE(@string, '－', '-');

SET @string = REPLACE(@string, '＝', '=');

SET @string = REPLACE(@string, '＾', '^');

SET @string = REPLACE(@string, '～', '~');

SET @string = REPLACE(@string, '￥', '\');

SET @string = REPLACE(@string, '｜', '|');

SET @string = REPLACE(@string, '‘', '`');

SET @string = REPLACE(@string, '「', '[');

SET @string = REPLACE(@string, '［', '[');

SET @string = REPLACE(@string, '｛', '{');

SET @string = REPLACE(@string, '＋', '+');

SET @string = REPLACE(@string, '；', ';');

SET @string = REPLACE(@string, '＊', '*');

SET @string = REPLACE(@string, '：', ':');

SET @string = REPLACE(@string, '」', ']');

SET @string = REPLACE(@string, '］', ']');

SET @string = REPLACE(@string, '｝', '}');

SET @string = REPLACE(@string, '、', ',');

SET @string = REPLACE(@string, '，', ',');

SET @string = REPLACE(@string, '＜', '<');

SET @string = REPLACE(@string, '。', '.');

SET @string = REPLACE(@string, '．', '.');

SET @string = REPLACE(@string, '＞', '>');

SET @string = REPLACE(@string, '／', '/');

SET @string = REPLACE(@string, '・', '/');

SET @string = REPLACE(@string, '？', '?');

SET @string = REPLACE(@string, '＿', '_');

SET @string = REPLACE(@string, '×', '*');

SET @string = REPLACE(@string, '÷', '/');

SET @string = REPLACE(@string, '　', ' ');

SET @string = REPLACE(@string, '〈', '(');

SET @string = REPLACE(@string, '【', '[');

SET @string = REPLACE(@string, '『', '[');

SET @string = REPLACE(@string, '〔', '[');

SET @string = REPLACE(@string, '≪', '<<');

SET @string = REPLACE(@string, '《', '((');

SET @string = REPLACE(@string, '〉', ')');

SET @string = REPLACE(@string, '】', ']');

SET @string = REPLACE(@string, '』', ']');

SET @string = REPLACE(@string, '〕', ']');

SET @string = REPLACE(@string, '≫', '>>');

SET @string = REPLACE(@string, '》', '))');

/* カタカナ */

-- 濁音、半濁音（半角2文字へ変換）

SET @string = REPLACE(@string, 'ヴ', 'ｳﾞ');

SET @string = REPLACE(@string, 'ガ', 'ｶﾞ');

SET @string = REPLACE(@string, 'ギ', 'ｷﾞ');

SET @string = REPLACE(@string, 'グ', 'ｸﾞ');

SET @string = REPLACE(@string, 'ゲ', 'ｹﾞ');

SET @string = REPLACE(@string, 'ゴ', 'ｺﾞ');

SET @string = REPLACE(@string, 'ザ', 'ｻﾞ');

SET @string = REPLACE(@string, 'ジ', 'ｼﾞ');

SET @string = REPLACE(@string, 'ズ', 'ｽﾞ');

SET @string = REPLACE(@string, 'ゼ', 'ｾﾞ');

SET @string = REPLACE(@string, 'ゾ', 'ｿﾞ');

SET @string = REPLACE(@string, 'ダ', 'ﾀﾞ');

SET @string = REPLACE(@string, 'ヂ', 'ﾁﾞ');

SET @string = REPLACE(@string, 'ヅ', 'ﾂﾞ');

SET @string = REPLACE(@string, 'デ', 'ﾃﾞ');

SET @string = REPLACE(@string, 'ド', 'ﾄﾞ');

SET @string = REPLACE(@string, 'バ', 'ﾊﾞ');

SET @string = REPLACE(@string, 'ビ', 'ﾋﾞ');

SET @string = REPLACE(@string, 'ブ', 'ﾌﾞ');

SET @string = REPLACE(@string, 'ベ', 'ﾍﾞ');

SET @string = REPLACE(@string, 'ボ', 'ﾎﾞ');

SET @string = REPLACE(@string, 'パ', 'ﾊﾟ');

SET @string = REPLACE(@string, 'ピ', 'ﾋﾟ');

SET @string = REPLACE(@string, 'プ', 'ﾌﾟ');

SET @string = REPLACE(@string, 'ペ', 'ﾍﾟ');

SET @string = REPLACE(@string, 'ポ', 'ﾎﾟ');

-- 通常

SET @string = REPLACE(@string, 'ア', 'ｱ');

SET @string = REPLACE(@string, 'イ', 'ｲ');

SET @string = REPLACE(@string, 'ウ', 'ｳ');

SET @string = REPLACE(@string, 'エ', 'ｴ');

SET @string = REPLACE(@string, 'オ', 'ｵ');

SET @string = REPLACE(@string, 'カ', 'ｶ');

SET @string = REPLACE(@string, 'キ', 'ｷ');

SET @string = REPLACE(@string, 'ク', 'ｸ');

SET @string = REPLACE(@string, 'ケ', 'ｹ');

SET @string = REPLACE(@string, 'コ', 'ｺ');

SET @string = REPLACE(@string, 'サ', 'ｻ');

SET @string = REPLACE(@string, 'シ', 'ｼ');

SET @string = REPLACE(@string, 'ス', 'ｽ');

SET @string = REPLACE(@string, 'セ', 'ｾ');

SET @string = REPLACE(@string, 'ソ', 'ｿ');

SET @string = REPLACE(@string, 'タ', 'ﾀ');

SET @string = REPLACE(@string, 'チ', 'ﾁ');

SET @string = REPLACE(@string, 'ツ', 'ﾂ');

SET @string = REPLACE(@string, 'テ', 'ﾃ');

SET @string = REPLACE(@string, 'ト', 'ﾄ');

SET @string = REPLACE(@string, 'ナ', 'ﾅ');

SET @string = REPLACE(@string, 'ニ', 'ﾆ');

SET @string = REPLACE(@string, 'ヌ', 'ﾇ');

SET @string = REPLACE(@string, 'ネ', 'ﾈ');

SET @string = REPLACE(@string, 'ノ', 'ﾉ');

SET @string = REPLACE(@string, 'ハ', 'ﾊ');

SET @string = REPLACE(@string, 'ヒ', 'ﾋ');

SET @string = REPLACE(@string, 'フ', 'ﾌ');

SET @string = REPLACE(@string, 'ヘ', 'ﾍ');

SET @string = REPLACE(@string, 'ホ', 'ﾎ');

SET @string = REPLACE(@string, 'マ', 'ﾏ');

SET @string = REPLACE(@string, 'ミ', 'ﾐ');

SET @string = REPLACE(@string, 'ム', 'ﾑ');

SET @string = REPLACE(@string, 'メ', 'ﾒ');

SET @string = REPLACE(@string, 'モ', 'ﾓ');

SET @string = REPLACE(@string, 'ヤ', 'ﾔ');

SET @string = REPLACE(@string, 'ユ', 'ﾕ');

SET @string = REPLACE(@string, 'ヨ', 'ﾖ');

SET @string = REPLACE(@string, 'ラ', 'ﾗ');

SET @string = REPLACE(@string, 'リ', 'ﾘ');

SET @string = REPLACE(@string, 'ル', 'ﾙ');

SET @string = REPLACE(@string, 'レ', 'ﾚ');

SET @string = REPLACE(@string, 'ロ', 'ﾛ');

SET @string = REPLACE(@string, 'ワ', 'ﾜ');

SET @string = REPLACE(@string, 'ヲ', 'ｦ');

SET @string = REPLACE(@string, 'ン', 'ﾝ');

-- 小文字

SET @string = REPLACE(@string, 'ァ', 'ｧ');

SET @string = REPLACE(@string, 'ィ', 'ｨ');

SET @string = REPLACE(@string, 'ゥ', 'ｩ');

SET @string = REPLACE(@string, 'ェ', 'ｪ');

SET @string = REPLACE(@string, 'ォ', 'ｫ');

SET @string = REPLACE(@string, 'ッ', 'ｯ');

SET @string = REPLACE(@string, 'ャ', 'ｬ');

SET @string = REPLACE(@string, 'ュ', 'ｭ');

SET @string = REPLACE(@string, 'ョ', 'ｮ');

SET @string = REPLACE(@string, 'ヶ', 'ｹ');

SET @string = REPLACE(@string, 'ヵ', 'ｶ');

/* 数字 */

SET @string = REPLACE(@string, '０', '0');

SET @string = REPLACE(@string, '１', '1');

SET @string = REPLACE(@string, '２', '2');

SET @string = REPLACE(@string, '３', '3');

SET @string = REPLACE(@string, '４', '4');

SET @string = REPLACE(@string, '５', '5');

SET @string = REPLACE(@string, '６', '6');

SET @string = REPLACE(@string, '７', '7');

SET @string = REPLACE(@string, '８', '8');

SET @string = REPLACE(@string, '９', '9');

SELECT @string;

半角から全角へ変換

-- 変換する文字列
DECLARE @string nvarchar(4000);
SET @string = N'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ!"#$%&''()ｰ-=^~\|`[{+;*:]},<.>/?_* ｳﾞｶﾞｷﾞｸﾞｹﾞｺﾞｻﾞｼﾞｽﾞｾﾞｿﾞﾀﾞﾁﾞﾂﾞﾃﾞﾄﾞﾊﾞﾋﾞﾌﾞﾍﾞﾎﾞﾊﾟﾋﾟﾌﾟﾍﾟﾎﾟｱｲｳｴｵｶｷｸｹｺｻｼｽｾｿﾀﾁﾂﾃﾄﾅﾆﾇﾈﾉﾊﾋﾌﾍﾎﾏﾐﾑﾒﾓﾔﾕﾖﾗﾘﾙﾚﾛﾜｦﾝｧｨｩｪｫｯｬｭｮｹｶ0123456789';

/* 小文字アルファベット */
SET @string = REPLACE(@string, 'a', 'ａ');
SET @string = REPLACE(@string, 'b', 'ｂ');
SET @string = REPLACE(@string, 'c', 'ｃ');
SET @string = REPLACE(@string, 'd', 'ｄ');
SET @string = REPLACE(@string, 'e', 'ｅ');
SET @string = REPLACE(@string, 'f', 'ｆ');
SET @string = REPLACE(@string, 'g', 'ｇ');
SET @string = REPLACE(@string, 'h', 'ｈ');
SET @string = REPLACE(@string, 'i', 'ｉ');
SET @string = REPLACE(@string, 'j', 'ｊ');
SET @string = REPLACE(@string, 'k', 'ｋ');
SET @string = REPLACE(@string, 'l', 'ｌ');
SET @string = REPLACE(@string, 'm', 'ｍ');
SET @string = REPLACE(@string, 'n', 'ｎ');
SET @string = REPLACE(@string, 'o', 'ｏ');
SET @string = REPLACE(@string, 'p', 'ｐ');
SET @string = REPLACE(@string, 'q', 'ｑ');
SET @string = REPLACE(@string, 'r', 'ｒ');
SET @string = REPLACE(@string, 's', 'ｓ');
SET @string = REPLACE(@string, 't', 'ｔ');
SET @string = REPLACE(@string, 'u', 'ｕ');
SET @string = REPLACE(@string, 'v', 'ｖ');
SET @string = REPLACE(@string, 'w', 'ｗ');
SET @string = REPLACE(@string, 'x', 'ｘ');
SET @string = REPLACE(@string, 'y', 'ｙ');
SET @string = REPLACE(@string, 'z', 'ｚ');
/* 大文字アルファベット */
SET @string = REPLACE(@string, 'A', 'Ａ');
SET @string = REPLACE(@string, 'B', 'Ｂ');
SET @string = REPLACE(@string, 'C', 'Ｃ');
SET @string = REPLACE(@string, 'D', 'Ｄ');
SET @string = REPLACE(@string, 'E', 'Ｅ');
SET @string = REPLACE(@string, 'F', 'Ｆ');
SET @string = REPLACE(@string, 'G', 'Ｇ');
SET @string = REPLACE(@string, 'H', 'Ｈ');
SET @string = REPLACE(@string, 'I', 'Ｉ');
SET @string = REPLACE(@string, 'J', 'Ｊ');
SET @string = REPLACE(@string, 'K', 'Ｋ');
SET @string = REPLACE(@string, 'L', 'Ｌ');
SET @string = REPLACE(@string, 'M', 'Ｍ');
SET @string = REPLACE(@string, 'N', 'Ｎ');
SET @string = REPLACE(@string, 'O', 'Ｏ');
SET @string = REPLACE(@string, 'P', 'Ｐ');
SET @string = REPLACE(@string, 'Q', 'Ｑ');
SET @string = REPLACE(@string, 'R', 'Ｒ');
SET @string = REPLACE(@string, 'S', 'Ｓ');
SET @string = REPLACE(@string, 'T', 'Ｔ');
SET @string = REPLACE(@string, 'U', 'Ｕ');
SET @string = REPLACE(@string, 'V', 'Ｖ');
SET @string = REPLACE(@string, 'W', 'Ｗ');
SET @string = REPLACE(@string, 'X', 'Ｘ');
SET @string = REPLACE(@string, 'Y', 'Ｙ');
SET @string = REPLACE(@string, 'Z', 'Ｚ');
/* 記号など */
SET @string = REPLACE(@string, '!', '！');

SET @string = REPLACE(@string, '"', '”');
-- SET @string = REPLACE(@string, '"', '“');

SET @string = REPLACE(@string, '#', '＃');
SET @string = REPLACE(@string, '$', '＄');
SET @string = REPLACE(@string, '%', '％');
SET @string = REPLACE(@string, '&', '＆');
SET @string = REPLACE(@string, '''', '’');
SET @string = REPLACE(@string, '(', '（');
SET @string = REPLACE(@string, ')', '）');
SET @string = REPLACE(@string, 'ｰ', 'ー');
SET @string = REPLACE(@string, '-', '－');
SET @string = REPLACE(@string, '=', '＝');
SET @string = REPLACE(@string, '^', '＾');
SET @string = REPLACE(@string, '~', '～');
SET @string = REPLACE(@string, '\', '￥');
SET @string = REPLACE(@string, '|', '｜');
SET @string = REPLACE(@string, '`', '‘');

SET @string = REPLACE(@string, '[', '「');
-- SET @string = REPLACE(@string, '[', '［');

SET @string = REPLACE(@string, '{', '｛');
SET @string = REPLACE(@string, '+', '＋');
SET @string = REPLACE(@string, ';', '；');
SET @string = REPLACE(@string, '*', '＊');
SET @string = REPLACE(@string, ':', '：');

SET @string = REPLACE(@string, ']', '」');
-- SET @string = REPLACE(@string, ']', '］');

SET @string = REPLACE(@string, '}', '｝');

SET @string = REPLACE(@string, ',', '、');
-- SET @string = REPLACE(@string, ',', '，');

SET @string = REPLACE(@string, '<', '＜');

SET @string = REPLACE(@string, '.', '。');
-- SET @string = REPLACE(@string, '.', '．');

SET @string = REPLACE(@string, '>', '＞');

SET @string = REPLACE(@string, '/', '／');
-- SET @string = REPLACE(@string, '/', '・');

SET @string = REPLACE(@string, '?', '？');
SET @string = REPLACE(@string, '_', '＿');
SET @string = REPLACE(@string, '*', '×');

-- SET @string = REPLACE(@string, '/', '÷');

SET @string = REPLACE(@string, ' ', '　');

-- SET @string = REPLACE(@string, '(', '〈');
-- SET @string = REPLACE(@string, '[', '【');
-- SET @string = REPLACE(@string, '[', '『');
-- SET @string = REPLACE(@string, '[', '〔');
-- SET @string = REPLACE(@string, '<<', '≪');
-- SET @string = REPLACE(@string, '((', '《');
-- SET @string = REPLACE(@string, ')', '〉');
-- SET @string = REPLACE(@string, ']', '】');
-- SET @string = REPLACE(@string, ']', '』');
-- SET @string = REPLACE(@string, ']', '〕');
-- SET @string = REPLACE(@string, '>>', '≫');
-- SET @string = REPLACE(@string, '))', '》');

/* カタカナ */
-- 濁音、半濁音（全角1文字へ変換）
SET @string = REPLACE(@string, 'ｳﾞ', 'ヴ');
SET @string = REPLACE(@string, 'ｶﾞ', 'ガ');
SET @string = REPLACE(@string, 'ｷﾞ', 'ギ');
SET @string = REPLACE(@string, 'ｸﾞ', 'グ');
SET @string = REPLACE(@string, 'ｹﾞ', 'ゲ');
SET @string = REPLACE(@string, 'ｺﾞ', 'ゴ');
SET @string = REPLACE(@string, 'ｻﾞ', 'ザ');
SET @string = REPLACE(@string, 'ｼﾞ', 'ジ');
SET @string = REPLACE(@string, 'ｽﾞ', 'ズ');
SET @string = REPLACE(@string, 'ｾﾞ', 'ゼ');
SET @string = REPLACE(@string, 'ｿﾞ', 'ゾ');
SET @string = REPLACE(@string, 'ﾀﾞ', 'ダ');
SET @string = REPLACE(@string, 'ﾁﾞ', 'ヂ');
SET @string = REPLACE(@string, 'ﾂﾞ', 'ヅ');
SET @string = REPLACE(@string, 'ﾃﾞ', 'デ');
SET @string = REPLACE(@string, 'ﾄﾞ', 'ド');
SET @string = REPLACE(@string, 'ﾊﾞ', 'バ');
SET @string = REPLACE(@string, 'ﾋﾞ', 'ビ');
SET @string = REPLACE(@string, 'ﾌﾞ', 'ブ');
SET @string = REPLACE(@string, 'ﾍﾞ', 'ベ');
SET @string = REPLACE(@string, 'ﾎﾞ', 'ボ');
SET @string = REPLACE(@string, 'ﾊﾟ', 'パ');
SET @string = REPLACE(@string, 'ﾋﾟ', 'ピ');
SET @string = REPLACE(@string, 'ﾌﾟ', 'プ');
SET @string = REPLACE(@string, 'ﾍﾟ', 'ペ');
SET @string = REPLACE(@string, 'ﾎﾟ', 'ポ');
-- 通常
SET @string = REPLACE(@string, 'ｱ', 'ア');
SET @string = REPLACE(@string, 'ｲ', 'イ');
SET @string = REPLACE(@string, 'ｳ', 'ウ');
SET @string = REPLACE(@string, 'ｴ', 'エ');
SET @string = REPLACE(@string, 'ｵ', 'オ');
SET @string = REPLACE(@string, 'ｶ', 'カ');
SET @string = REPLACE(@string, 'ｷ', 'キ');
SET @string = REPLACE(@string, 'ｸ', 'ク');
SET @string = REPLACE(@string, 'ｹ', 'ケ');
SET @string = REPLACE(@string, 'ｺ', 'コ');
SET @string = REPLACE(@string, 'ｻ', 'サ');
SET @string = REPLACE(@string, 'ｼ', 'シ');
SET @string = REPLACE(@string, 'ｽ', 'ス');
SET @string = REPLACE(@string, 'ｾ', 'セ');
SET @string = REPLACE(@string, 'ｿ', 'ソ');
SET @string = REPLACE(@string, 'ﾀ', 'タ');
SET @string = REPLACE(@string, 'ﾁ', 'チ');
SET @string = REPLACE(@string, 'ﾂ', 'ツ');
SET @string = REPLACE(@string, 'ﾃ', 'テ');
SET @string = REPLACE(@string, 'ﾄ', 'ト');
SET @string = REPLACE(@string, 'ﾅ', 'ナ');
SET @string = REPLACE(@string, 'ﾆ', 'ニ');
SET @string = REPLACE(@string, 'ﾇ', 'ヌ');
SET @string = REPLACE(@string, 'ﾈ', 'ネ');
SET @string = REPLACE(@string, 'ﾉ', 'ノ');
SET @string = REPLACE(@string, 'ﾊ', 'ハ');
SET @string = REPLACE(@string, 'ﾋ', 'ヒ');
SET @string = REPLACE(@string, 'ﾌ', 'フ');
SET @string = REPLACE(@string, 'ﾍ', 'ヘ');
SET @string = REPLACE(@string, 'ﾎ', 'ホ');
SET @string = REPLACE(@string, 'ﾏ', 'マ');
SET @string = REPLACE(@string, 'ﾐ', 'ミ');
SET @string = REPLACE(@string, 'ﾑ', 'ム');
SET @string = REPLACE(@string, 'ﾒ', 'メ');
SET @string = REPLACE(@string, 'ﾓ', 'モ');
SET @string = REPLACE(@string, 'ﾔ', 'ヤ');
SET @string = REPLACE(@string, 'ﾕ', 'ユ');
SET @string = REPLACE(@string, 'ﾖ', 'ヨ');
SET @string = REPLACE(@string, 'ﾗ', 'ラ');
SET @string = REPLACE(@string, 'ﾘ', 'リ');
SET @string = REPLACE(@string, 'ﾙ', 'ル');
SET @string = REPLACE(@string, 'ﾚ', 'レ');
SET @string = REPLACE(@string, 'ﾛ', 'ロ');
SET @string = REPLACE(@string, 'ﾜ', 'ワ');
SET @string = REPLACE(@string, 'ｦ', 'ヲ');
SET @string = REPLACE(@string, 'ﾝ', 'ン');
-- 小文字
SET @string = REPLACE(@string, 'ｧ', 'ァ');
SET @string = REPLACE(@string, 'ｨ', 'ィ');
SET @string = REPLACE(@string, 'ｩ', 'ゥ');
SET @string = REPLACE(@string, 'ｪ', 'ェ');
SET @string = REPLACE(@string, 'ｫ', 'ォ');
SET @string = REPLACE(@string, 'ｯ', 'ッ');
SET @string = REPLACE(@string, 'ｬ', 'ャ');
SET @string = REPLACE(@string, 'ｭ', 'ュ');
SET @string = REPLACE(@string, 'ｮ', 'ョ');

-- SET @string = REPLACE(@string, 'ｹ', 'ヶ');
-- SET @string = REPLACE(@string, 'ｶ', 'ヵ');

/* 数字 */
SET @string = REPLACE(@string, '0', '０');
SET @string = REPLACE(@string, '1', '１');
SET @string = REPLACE(@string, '2', '２');
SET @string = REPLACE(@string, '3', '３');
SET @string = REPLACE(@string, '4', '４');
SET @string = REPLACE(@string, '5', '５');
SET @string = REPLACE(@string, '6', '６');
SET @string = REPLACE(@string, '7', '７');
SET @string = REPLACE(@string, '8', '８');
SET @string = REPLACE(@string, '9', '９');

SELECT @string;

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

-- 変換する文字列

DECLARE @string nvarchar(4000);

SET @string = N'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ!"#$%&''()ｰ-=^~\|`[{+;*:]},<.>/?_* ｳﾞｶﾞｷﾞｸﾞｹﾞｺﾞｻﾞｼﾞｽﾞｾﾞｿﾞﾀﾞﾁﾞﾂﾞﾃﾞﾄﾞﾊﾞﾋﾞﾌﾞﾍﾞﾎﾞﾊﾟﾋﾟﾌﾟﾍﾟﾎﾟｱｲｳｴｵｶｷｸｹｺｻｼｽｾｿﾀﾁﾂﾃﾄﾅﾆﾇﾈﾉﾊﾋﾌﾍﾎﾏﾐﾑﾒﾓﾔﾕﾖﾗﾘﾙﾚﾛﾜｦﾝｧｨｩｪｫｯｬｭｮｹｶ0123456789';

/* 小文字アルファベット */

SET @string = REPLACE(@string, 'a', 'ａ');

SET @string = REPLACE(@string, 'b', 'ｂ');

SET @string = REPLACE(@string, 'c', 'ｃ');

SET @string = REPLACE(@string, 'd', 'ｄ');

SET @string = REPLACE(@string, 'e', 'ｅ');

SET @string = REPLACE(@string, 'f', 'ｆ');

SET @string = REPLACE(@string, 'g', 'ｇ');

SET @string = REPLACE(@string, 'h', 'ｈ');

SET @string = REPLACE(@string, 'i', 'ｉ');

SET @string = REPLACE(@string, 'j', 'ｊ');

SET @string = REPLACE(@string, 'k', 'ｋ');

SET @string = REPLACE(@string, 'l', 'ｌ');

SET @string = REPLACE(@string, 'm', 'ｍ');

SET @string = REPLACE(@string, 'n', 'ｎ');

SET @string = REPLACE(@string, 'o', 'ｏ');

SET @string = REPLACE(@string, 'p', 'ｐ');

SET @string = REPLACE(@string, 'q', 'ｑ');

SET @string = REPLACE(@string, 'r', 'ｒ');

SET @string = REPLACE(@string, 's', 'ｓ');

SET @string = REPLACE(@string, 't', 'ｔ');

SET @string = REPLACE(@string, 'u', 'ｕ');

SET @string = REPLACE(@string, 'v', 'ｖ');

SET @string = REPLACE(@string, 'w', 'ｗ');

SET @string = REPLACE(@string, 'x', 'ｘ');

SET @string = REPLACE(@string, 'y', 'ｙ');

SET @string = REPLACE(@string, 'z', 'ｚ');

/* 大文字アルファベット */

SET @string = REPLACE(@string, 'A', 'Ａ');

SET @string = REPLACE(@string, 'B', 'Ｂ');

SET @string = REPLACE(@string, 'C', 'Ｃ');

SET @string = REPLACE(@string, 'D', 'Ｄ');

SET @string = REPLACE(@string, 'E', 'Ｅ');

SET @string = REPLACE(@string, 'F', 'Ｆ');

SET @string = REPLACE(@string, 'G', 'Ｇ');

SET @string = REPLACE(@string, 'H', 'Ｈ');

SET @string = REPLACE(@string, 'I', 'Ｉ');

SET @string = REPLACE(@string, 'J', 'Ｊ');

SET @string = REPLACE(@string, 'K', 'Ｋ');

SET @string = REPLACE(@string, 'L', 'Ｌ');

SET @string = REPLACE(@string, 'M', 'Ｍ');

SET @string = REPLACE(@string, 'N', 'Ｎ');

SET @string = REPLACE(@string, 'O', 'Ｏ');

SET @string = REPLACE(@string, 'P', 'Ｐ');

SET @string = REPLACE(@string, 'Q', 'Ｑ');

SET @string = REPLACE(@string, 'R', 'Ｒ');

SET @string = REPLACE(@string, 'S', 'Ｓ');

SET @string = REPLACE(@string, 'T', 'Ｔ');

SET @string = REPLACE(@string, 'U', 'Ｕ');

SET @string = REPLACE(@string, 'V', 'Ｖ');

SET @string = REPLACE(@string, 'W', 'Ｗ');

SET @string = REPLACE(@string, 'X', 'Ｘ');

SET @string = REPLACE(@string, 'Y', 'Ｙ');

SET @string = REPLACE(@string, 'Z', 'Ｚ');

/* 記号など */

SET @string = REPLACE(@string, '!', '！');

SET @string = REPLACE(@string, '"', '”');

-- SET @string = REPLACE(@string, '"', '“');

SET @string = REPLACE(@string, '#', '＃');

SET @string = REPLACE(@string, '$', '＄');

SET @string = REPLACE(@string, '%', '％');

SET @string = REPLACE(@string, '&', '＆');

SET @string = REPLACE(@string, '''', '’');

SET @string = REPLACE(@string, '(', '（');

SET @string = REPLACE(@string, ')', '）');

SET @string = REPLACE(@string, 'ｰ', 'ー');

SET @string = REPLACE(@string, '-', '－');

SET @string = REPLACE(@string, '=', '＝');

SET @string = REPLACE(@string, '^', '＾');

SET @string = REPLACE(@string, '~', '～');

SET @string = REPLACE(@string, '\', '￥');

SET @string = REPLACE(@string, '|', '｜');

SET @string = REPLACE(@string, '`', '‘');

SET @string = REPLACE(@string, '[', '「');

-- SET @string = REPLACE(@string, '[', '［');

SET @string = REPLACE(@string, '{', '｛');

SET @string = REPLACE(@string, '+', '＋');

SET @string = REPLACE(@string, ';', '；');

SET @string = REPLACE(@string, '*', '＊');

SET @string = REPLACE(@string, ':', '：');

SET @string = REPLACE(@string, ']', '」');

-- SET @string = REPLACE(@string, ']', '］');

SET @string = REPLACE(@string, '}', '｝');

SET @string = REPLACE(@string, ',', '、');

-- SET @string = REPLACE(@string, ',', '，');

SET @string = REPLACE(@string, '<', '＜');

SET @string = REPLACE(@string, '.', '。');

-- SET @string = REPLACE(@string, '.', '．');

SET @string = REPLACE(@string, '>', '＞');

SET @string = REPLACE(@string, '/', '／');

-- SET @string = REPLACE(@string, '/', '・');

SET @string = REPLACE(@string, '?', '？');

SET @string = REPLACE(@string, '_', '＿');

SET @string = REPLACE(@string, '*', '×');

-- SET @string = REPLACE(@string, '/', '÷');

SET @string = REPLACE(@string, ' ', '　');

-- SET @string = REPLACE(@string, '(', '〈');

-- SET @string = REPLACE(@string, '[', '【');

-- SET @string = REPLACE(@string, '[', '『');

-- SET @string = REPLACE(@string, '[', '〔');

-- SET @string = REPLACE(@string, '<<', '≪');

-- SET @string = REPLACE(@string, '((', '《');

-- SET @string = REPLACE(@string, ')', '〉');

-- SET @string = REPLACE(@string, ']', '】');

-- SET @string = REPLACE(@string, ']', '』');

-- SET @string = REPLACE(@string, ']', '〕');

-- SET @string = REPLACE(@string, '>>', '≫');

-- SET @string = REPLACE(@string, '))', '》');

/* カタカナ */

-- 濁音、半濁音（全角1文字へ変換）

SET @string = REPLACE(@string, 'ｳﾞ', 'ヴ');

SET @string = REPLACE(@string, 'ｶﾞ', 'ガ');

SET @string = REPLACE(@string, 'ｷﾞ', 'ギ');

SET @string = REPLACE(@string, 'ｸﾞ', 'グ');

SET @string = REPLACE(@string, 'ｹﾞ', 'ゲ');

SET @string = REPLACE(@string, 'ｺﾞ', 'ゴ');

SET @string = REPLACE(@string, 'ｻﾞ', 'ザ');

SET @string = REPLACE(@string, 'ｼﾞ', 'ジ');

SET @string = REPLACE(@string, 'ｽﾞ', 'ズ');

SET @string = REPLACE(@string, 'ｾﾞ', 'ゼ');

SET @string = REPLACE(@string, 'ｿﾞ', 'ゾ');

SET @string = REPLACE(@string, 'ﾀﾞ', 'ダ');

SET @string = REPLACE(@string, 'ﾁﾞ', 'ヂ');

SET @string = REPLACE(@string, 'ﾂﾞ', 'ヅ');

SET @string = REPLACE(@string, 'ﾃﾞ', 'デ');

SET @string = REPLACE(@string, 'ﾄﾞ', 'ド');

SET @string = REPLACE(@string, 'ﾊﾞ', 'バ');

SET @string = REPLACE(@string, 'ﾋﾞ', 'ビ');

SET @string = REPLACE(@string, 'ﾌﾞ', 'ブ');

SET @string = REPLACE(@string, 'ﾍﾞ', 'ベ');

SET @string = REPLACE(@string, 'ﾎﾞ', 'ボ');

SET @string = REPLACE(@string, 'ﾊﾟ', 'パ');

SET @string = REPLACE(@string, 'ﾋﾟ', 'ピ');

SET @string = REPLACE(@string, 'ﾌﾟ', 'プ');

SET @string = REPLACE(@string, 'ﾍﾟ', 'ペ');

SET @string = REPLACE(@string, 'ﾎﾟ', 'ポ');

-- 通常

SET @string = REPLACE(@string, 'ｱ', 'ア');

SET @string = REPLACE(@string, 'ｲ', 'イ');

SET @string = REPLACE(@string, 'ｳ', 'ウ');

SET @string = REPLACE(@string, 'ｴ', 'エ');

SET @string = REPLACE(@string, 'ｵ', 'オ');

SET @string = REPLACE(@string, 'ｶ', 'カ');

SET @string = REPLACE(@string, 'ｷ', 'キ');

SET @string = REPLACE(@string, 'ｸ', 'ク');

SET @string = REPLACE(@string, 'ｹ', 'ケ');

SET @string = REPLACE(@string, 'ｺ', 'コ');

SET @string = REPLACE(@string, 'ｻ', 'サ');

SET @string = REPLACE(@string, 'ｼ', 'シ');

SET @string = REPLACE(@string, 'ｽ', 'ス');

SET @string = REPLACE(@string, 'ｾ', 'セ');

SET @string = REPLACE(@string, 'ｿ', 'ソ');

SET @string = REPLACE(@string, 'ﾀ', 'タ');

SET @string = REPLACE(@string, 'ﾁ', 'チ');

SET @string = REPLACE(@string, 'ﾂ', 'ツ');

SET @string = REPLACE(@string, 'ﾃ', 'テ');

SET @string = REPLACE(@string, 'ﾄ', 'ト');

SET @string = REPLACE(@string, 'ﾅ', 'ナ');

SET @string = REPLACE(@string, 'ﾆ', 'ニ');

SET @string = REPLACE(@string, 'ﾇ', 'ヌ');

SET @string = REPLACE(@string, 'ﾈ', 'ネ');

SET @string = REPLACE(@string, 'ﾉ', 'ノ');

SET @string = REPLACE(@string, 'ﾊ', 'ハ');

SET @string = REPLACE(@string, 'ﾋ', 'ヒ');

SET @string = REPLACE(@string, 'ﾌ', 'フ');

SET @string = REPLACE(@string, 'ﾍ', 'ヘ');

SET @string = REPLACE(@string, 'ﾎ', 'ホ');

SET @string = REPLACE(@string, 'ﾏ', 'マ');

SET @string = REPLACE(@string, 'ﾐ', 'ミ');

SET @string = REPLACE(@string, 'ﾑ', 'ム');

SET @string = REPLACE(@string, 'ﾒ', 'メ');

SET @string = REPLACE(@string, 'ﾓ', 'モ');

SET @string = REPLACE(@string, 'ﾔ', 'ヤ');

SET @string = REPLACE(@string, 'ﾕ', 'ユ');

SET @string = REPLACE(@string, 'ﾖ', 'ヨ');

SET @string = REPLACE(@string, 'ﾗ', 'ラ');

SET @string = REPLACE(@string, 'ﾘ', 'リ');

SET @string = REPLACE(@string, 'ﾙ', 'ル');

SET @string = REPLACE(@string, 'ﾚ', 'レ');

SET @string = REPLACE(@string, 'ﾛ', 'ロ');

SET @string = REPLACE(@string, 'ﾜ', 'ワ');

SET @string = REPLACE(@string, 'ｦ', 'ヲ');

SET @string = REPLACE(@string, 'ﾝ', 'ン');

-- 小文字

SET @string = REPLACE(@string, 'ｧ', 'ァ');

SET @string = REPLACE(@string, 'ｨ', 'ィ');

SET @string = REPLACE(@string, 'ｩ', 'ゥ');

SET @string = REPLACE(@string, 'ｪ', 'ェ');

SET @string = REPLACE(@string, 'ｫ', 'ォ');

SET @string = REPLACE(@string, 'ｯ', 'ッ');

SET @string = REPLACE(@string, 'ｬ', 'ャ');

SET @string = REPLACE(@string, 'ｭ', 'ュ');

SET @string = REPLACE(@string, 'ｮ', 'ョ');

-- SET @string = REPLACE(@string, 'ｹ', 'ヶ');

-- SET @string = REPLACE(@string, 'ｶ', 'ヵ');

/* 数字 */

SET @string = REPLACE(@string, '0', '０');

SET @string = REPLACE(@string, '1', '１');

SET @string = REPLACE(@string, '2', '２');

SET @string = REPLACE(@string, '3', '３');

SET @string = REPLACE(@string, '4', '４');

SET @string = REPLACE(@string, '5', '５');

SET @string = REPLACE(@string, '6', '６');

SET @string = REPLACE(@string, '7', '７');

SET @string = REPLACE(@string, '8', '８');

SET @string = REPLACE(@string, '9', '９');

SELECT @string;