If Exists - Select Prevent Repeating Code We receive an order list, and validate it starts with certain prefixes, example if OrderNumber does not start with ABC, than display order list to user as error. We use exists, to search for first existence, don't want to consume much performance time. If none exist, then we can start conducting other task in code.

Is there anyway in sql to get rid of the repetitive code? We have Many checks like this on multiple tables, trying to make code more efficient.

if exists
(
    select *
    from dbo.OrdersImport
    where left(OrderNumber,3) &lt;&gt; 'ABC'
)
begin
    select OrderNumber as OrderErrorList
    from dbo.OrdersImport
    where left(OrderNumber,3) &lt;&gt; 'ABC'
end
else
Unfortunately I'm afraid by trying to prevent repeating code you might end up in writing more code and making the query less readable.
But I believe this can be advantageous for you - take into account situations where in the test you would only have to search in a one or two tables, where in order to retrieve all the details you will have to join to several more. In those situations you can simplify the test query thus also making them quicker to execute.

And while we are at it, you might also consider changing your WHERE statement. Using functions in the predicate makes them not SARGable and prevent using indexes in those cases. 
A better approach in this example would be to check 

WHERE OrderNumber LIKE 'ABC%'


as the optimizer will perform conversion to something along the lines of

OrderNumber &gt;= 'ABC' AND OrderNumber &lt; 'ABD'


which supports the use of indexes.
So this would be Index Scan (using left()) versus Index Seek (using LIKE).