在T-SQL WHERE子句中使用条件

I have an existing T-SQL query that returns a list of customers who need to be sent updates. As a part of the WHERE clause, the query checks to make sure the version conforms to a length of 6, and then appends additional characters.I have an existing T-SQL query that returns a l