Field alias in Where statement

[bjornagin]

This should be a simple question.

I'm trying a query like:

SELECT Distinct Left(AuditNum, 4) AS Blah
FROM Audit
where Blah = 'Fred'

When I attempt to execute the query I get prompted for a parameter value "Blah".

Can't I use a field alias in my where clause?

Thanks

 

[hneal98]

That would not work. It would work if you had this in another query or table and then referenced it, but not in the same query. you would have to do it like this:

ECT Distinct Left(AuditNum, 4) AS Blah
FROM Audit
where Left(AuditNum, 4) = 'Fred'