Code to determine if a number ends in .9

[Leesha]

Hi,

I have a variety of [store_id] numbers that are either whole numbers or end in .9 or .1. I need to write conditional code based on whether the store ends with .9 or .0 or is whole number. So for example, w-What would the code look like to determine if the number ended in .9

Thanks!
Leesha

[mbarron]

iif(Right([store_id],2) = .9,"Point_9","something else")

[Leesha]

Perfect!! Thank you! Leesha