Novice needs help writing a query. Thank you!

[LogicTeam1]

Can someone please help me write an SQL expression through a query to find all the AIN values in this solar data set where the last 3 digits of the number are greater than or equal to 900? I've tried using "Right([AIN],3) and it does not work. Thanks.

[ranman256]

select *, Right([ain],3) from table where Right([ain],3) >899

[LogicTeam1]

I'm sorry, could you be more descriptive about which cells I put those formulas in? Thank you!

[LogicTeam1]

I figured it out. THanks again for your help.