Is there any way to filter by the output format in sql server.
Below is my output :
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 :
Please help if there is any way to get this.