select psncode,* from bd_psndoc where psncode like '%H% 我需要不 ... Not( psncode like '%H% ) ... 将like改为except,试一试 ... 用NOT IN.
www.google.com.tw