Java method/program to search database, converting proper name to nicknames

I need a Java method/program that can take a proper name (i.e. Robert) and search a data base matching not only that name but any possible nick name combinations: Bob, Rob, Bobby, Robby, Rob, etc. Must be able to be used with SQL 2000.
Who is Participating?
marklorenzConnect With a Mentor Commented:
This will do what you need:

You need to do a join to another detail table containing nicknames. Name and Nickname tables would be in a one-to-many relation
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.