我需要转义[在sql Server的SQL查询中
select * from soMetable where name like '[something]';
我实际上正在寻找[之前的东西,我不希望它像一个通配符.我试过了 ：
select * from soMetable where name like ''[something]';
但是从这里得到错误信息：
Msg 102,Level 15,State 1,Line 1 Incorrect Syntax near ‘something’.
Msg 105,Line 1 Unclosed quotation mark after the
character string ‘;
