Using alias in where condition

[Alex]

Can we do

Select BookNo as Catalog from Books
where Catalog = 12356

I need to find the way to use alias in "where" for very complex query
Is anyone has way around it ?
Thank you

[Paul]

Use a stored procedure.....

create procedure <procedure name>
@catalog
as

Select BookNo as Catalog from Books
where Catalog = @catalog


call it like >> exec <procedure name> 12356

------------
Alex at 3/1/01 5:50:16 PM

Can we do

Select BookNo as Catalog from Books
where Catalog = 12356

I need to find the way to use alias in &#34;where&#34; for very complex query
Is anyone has way around it ?
Thank you