[jdjlist] Re: String List Compare

[Paul Franz]

Title: String List Compare

I think you have the best and fastest solution in number 3. Of course if this a filter of some sort you should be able to use the LIKE in the where clause. For example,       select * from some_table where states like '%CA%'   Which is probably a better solution if you are doing it to filter out records.   Paul Franz ----- Original Message ----- From: Greg Nudelman To: jdjlist Sent: Wednesday, March 26, 2003 1:31 PM Subject: [jdjlist] String List Compare I have a DB field of user-entered 2-letter states, separated by a comma. states = "CA, OR, TX"; or it could be states = " CA,OR,TX, HI "; in other words, spacing is inconsistent, but case seems to be OK. I need to relaibly and FAST! answer: is state = "CA" in states Any ideas? Greg ---------------------------------------------- P.S. this is what we got so far: 1) run a perl script on DB that will remove the extra spacing 2) add the flanking commas to both: state = ",CA,"; states = ",CA,OR,TX,HI,"; 3) states.indexOf(state) != -1 Greg --- You are currently subscribed to jdjlist as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] http://www.sys-con.com/fusetalk --- You are currently subscribed to jdjlist as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] http://www.sys-con.com/fusetalk