SQL query to get a value

Question

Hi,

I want to get the values A6, B5 from the values of a table column called (property).

Whatever i need the values, i get it after 4th "_(underscore)".


Example of the values are as follows:

yxmn_euheiu_uhfi_jdfhf_A6_hfurh
dsfsdgdf_dsgrgrd_rshrfhfd_hsdsg_B5_Dgsdgd_asgsgsd


Thanks allot

Darma