delete issue when sending multiple values 1

[bcardona]

if i send one value everything is fine, i.e. delete whatever from table where value ='100' now if i send multiple values i.e delete whatever from table where value = '100','101','102' and so on,

here is the actual results,

delete id from table where CAST(id As varChar(200)) ='88501, 88534, 88535, 88536, 88537, 88538, 88539, 88540, 88541, 88542, 88543, 88544, 88545, 88546'

it will not delete anything.any ideas

 

[Mike Lewis]

1. Ask in the right forum (mostly in your FrontEnd language one)
2. Give enough information what about you need.
3. Answer to the questions othe rmember asked.

I agree with all of that. It took much longer for us to figure out what the question was than it took to answer it.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk