select len(fmark),fmark from productholeboxdt
 where prodno = 'S110800508' and boxno = '02'

select len(fmark),* from productholeboxdt
 where prodno = 'S110800508' and boxno = '02'  ltrim(rtrim(fmark)) = N'貼貼紙' 

select len(fmark),* from productholeboxdt
 where prodno = 'S110800508' and boxno = '02'
and ltrim(rtrim(fmark)) like '貼貼紙 %'  --这地方有个空格，空格也是要占位的。 数据里面没有带 貼貼紙 
的数据