Thanx for the help yesterday..I was able to break down the string from my database:

('MCKINNEY','TX'),('ALLEN','TX'),('ANNA','TX')

using:

String strInput = userData.getMhtCityList();
String strProcess=null;
String strOutputs[]=null;
if(strInput!=null){
strProcess=strInput.substring(1,strInput.length()-1);
System.out.println(strProcess);
strOutputs=strProcess.split("\\'\\),\\(\\'");
}

worked like a charm

only problem now is those damn apostophies

'MCKINNEY','TX
ALLEN','TX
ANNA','TX'

any suggestions on stripping out the apostrophies out the array?

thanx

replace({STRING_ARRAY},{VALUE TO FIND},{REPLACE VAL})

Why wouldn't you look this up, its only a google search away.

why google when you have daniweb?

no joke...I love this place..I havent used it in months, but when I did yesterday..I got like 4-5 positive responses...google is cool...but this is a more refined a focused search for help

btw...thanx for the method..it worked buddy!!