How to filter column output based on specific format value Is there any way to filter by the output format in sql server.

Below is my output :


  SQLOutput
  
  AB-123456-99 Checker
  
  123456-10000-00 2016
  
  111119-20000-00 2016


How can I get the expected output as below, 

the query should exclude all the column values which are in the format 


  123456-10000-00  -- xxxxxx-xxxxx-xx


If the column output has this format that value should be excluded from results.

and my final output should be as below :


  SQLOutput
  
  AB-123456-99 Checker


Please help if there is any way to get this.
Assuming that your output is all one column, I would go with the conditional clause below. If you output is more than one column, then you can make the adjustments accordingly.

DECLARE @table TABLE
(Column1 VARCHAR(50))

INSERT INTO @table
        ( Column1 )
VALUES  ( 'AB-123456-99 Checker')
    ,('123456-10000-00 2016')
    ,('111119-20000-00 2016')


SELECT t.Column1 FROM @table AS t
WHERE t.Column1 NOT LIKE '[0-9][0-9][0-9][0-9][0-9][0-9]-[0-9][0-9][0-9][0-9][0-9]-[0-9][0-9]%'


So, you would essentially replace the x with [0-9] for numeric. If it was alpha, you would replace the x with [a-z] for case insensitive collations and [A-Za-z] for case sensitive collations. If it's alpha or numeric, it would be [0-9a-z] or [0-9A-Za-z]