Can I use and aliased Field in a WHERE condition ?

[Hiciano]

Hi. I am trying to use an alias field in my WHERE clause but I get an error.

The idea is this:

SELECT name,lastname,socsecid AS id FROM Tablex WHERE id=100

Is this correct ?

Thanks !

 

[tlbroadbent]

I don't believe that is allowable. Terry

http://members.home.net/tlbroadbent/prog.htm

Neither success nor failure is ever final. -Roger Babson

 

[CosmoKramer]

Terry's right...The alias acts only as a column header....

 

[Hiciano]

Guys, Thanks a lot for your answers. The thing is that Jet answers the following with the Alias name and not the real name of the field.

dbData.Recordset.Fields(1).Name

How can I make Jet to give me back the real name of the field and not the alias ?

 

[tlbroadbent]

I'm not exactly sure what you are getting at. You can remove the alias from the query.

SELECT name,lastname,socsecid FROM Tablex WHERE socsecid=100 Terry

http://members.home.net/tlbroadbent/prog.htm

"I'm not dumb. I just have a command of throughly useless information." - Calvin, of Calvin and Hobbes