Expanding search in list

[yelyah.nodrog]

Is there a way to expand the range in a list for searching?

For example we have a list of departments for our trust, They have to match up with the information held with HR or people will not be moved into the right departments / divisions/ cost centres in the organisational structure in hornbill. 

However the departments all start with a 3 letter/digit code and we have over 350 departments e.g.

When selecting a department in the front end on the intelligent capture from the drop down you have to know the 3 digit code to be able to start typing it to get to the right department quickly.
Is there a way to extend where the search looks so for example if you didn't know that squirrel ward was 2AB, you could type in SQU and it would bring up anything that matched that?

Hayley.

 

[yelyah.nodrog]

any ideas on this one?

[Steve Giller]

The only idea I'd have would be to have them described as, for example, Victoria Ward [5CE] rather than 5CE - Victoria Ward.