View Single Post

   
  #1 (permalink)  
Old 02-28-2008, 08:31 AM
Josselin
 
Posts: n/a
Default where value in array

Is teher anyway to replace a where clause like :
I have a serie of string values in an array ["01", "02", "58", "61"...]

is there anyway to not to build the SELECT clause with a loop :
WHERE dpt_code = '01' OR dpt_code = '02' OR dpt_code = '58' OR dpt_code
= '61'...
but rather use something like WHERE dpt_code IN [ a set.. of values]

thanks

joss



Reply With Quote