下表字符查找比较: SQLDAX Name LIKE 'SQLBI' Table[Name] = "SQLBI" Name LIKE 'SQLBI%' LEFT ( Table[Name], 5 ) = "SQLBI" Name LIKE '%SQLBI' RIGHT ( Table[Name], 5 ) = "SQLBI" Name LIKE '%SQLBI%' SEARCH ( "SQLBI" , Table[Name], 1, 0 ) > 0 for PowerPivot v1: IFERROR ( SEARCH ( "SQLBI" , Table[Name], 1 ), 0 ) > 0 Name LIKE 'SQLBI%Methodology' LEFT ( Table[Name], 5 ) = "SQLBI" && RIGHT ( Table[Name], 11 ) = "Methodology" Name LIKE 'SQLBI%Methodology%' LEFT ( Table[Name], 5 ) = "SQLBI" && SEARCH ( "Methodology" , Table[Name], 1, 0 ) > 0 Name LIKE '%SQLBI%Methodology%' SEARCH ( "SQLBI" , Table[Name], 1, 0 ) > 0 && SEARCH ( "Methodology" , Table[Name], 1, 0 ) > SEARCH ( "SQLBI" , Table[Name], 1, 0 )