How to find a image that does not matach a pattern
Q&A about the site for professional, enthusiast and amateur photographers
-- Searching a image for a pattern -- How to find a image that does not matach a pattern CREATE TABLE #t( [cpclid] [int] NOT NULL, [cpphoto] [image] NULL ) INSERT INTO #t ([cpclid] ,[cpphoto]) VALUES (0 ,0xFFD8FFE000104A4649460001) INSERT INTO #t ([cpclid] ,[cpphoto]) VALUES (1 ,0xFAD8FFE000104A4649460001) SELECT [cpclid], cpphoto FROM #t