如果包含扩展名的coloumn被称为扩展名，则在名为MyTable的表格中，

你可以像这样使用替换：

If the coloumn containg the extention is called "extension", in a table called "MyTable",
you can use replace like this:

SELECT Replace(Replace(extension, '{', '*.'), '}', ';') 
AS ext 
FROM MyTable

Best，

H

Best,
H

试试这个...

Try this...

SELECT REPLACE(REPLACE(REPLACE(coulum_extension,'{GIF}','*.GIF'), '{JPG}', "*.JPG"), "{PNG}", "*.PNG") FROM TableExtension ;