Hi,

We have some groups in our database. For instance named as follows:

002BBA1
021BBA1

...where the first two digits indicate the year of graduation. Now if I want to search for the class of 02 it finds of course all the people for 02, but also the people from the group 002BBA1.

How can I implement a phrase that checks if "02" is the searchstring and then says take all with /02*/ (which implies "not 002" - I guess).

I know thats a problem we should have thought about in the first place, but now that's the way it is...changing groupnames is not an option. As you can probably further tell, my knowledge in Perl is not very advanced...

Thanks a lot for your help,

Frank

I'm not sure how you are searching are you speaking of using a keyword search or a custom search form?

This thread may help:

http://gossamer-threads.com/p/92784
subject: searching first two characters of numerical value
sep - 8-jul-2000

if the url above doesn't open the correct thread, you can search the forum for the subject title or user.

A copy of this thread is also available in the FAQ below in the section "Searching".

You might also want to search the forum for "graduation" as I do remember a thread related to displaying partial year choices. It may have been for displaying on the home page with the category list mod?

Hope this helps

Unoffical DBMan FAQ
http://redundantcartridge.com/dbman/

Hi LoisC,

thanks for your answer, I took a look at the other thread and I think that will do it.

Thank you very much!

Frank