[GENERAL] Checking for a number

[Warren]

I need to check if the last two characters of a field are a number. I am 
trying something like this but it does not want to work.

substring(TRIM(field8) from '..$') SIMILAR TO '\d\d'
How should I do this?

--
Thanks,

Warren Bell

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
      choose an index scan if your joining column's datatypes do not
      match