pattern search results for smallint