query to find string which has last 5 characters as numbers

Hi,
How do i write a query which will search a varcharchar column for all the records which have their last 5 characters as numbers.

For example
'abcdef 12345'
'abcd 12'
'abcdwiwiwii 1234'

It should return me the 1st record only as the other 2 records do not have last 5 characters as numbers.

Please help!

Thanks
Anurag

also reply at
aminocha_at_UNIBIZ.COM

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!