Use Sql server column alias in where condition

Question

I am writing a sql server query with one column as a expression like

Select name , name + age as Test from myTable
where Test like '%b%';

Now i cannot use Test either i need to write

Select name , name + age as Test from myTable
where (name + age) like '%b%';

Now the expression (name + age) can be very big sometimes so cant i give it some alias and use it

Any help is appreciated,

Thank You

Answer 1

How about this way..

select name, Test
(
Select name , (name + age) as Test from myTable
) t
where Test like '%b%'

The query needs to be modified as it has syntax error:

So it should be written like

select name from
(
Select name , (name + age) as Test from myTable
) t
where Test like '%b%'