divide a string

[atse]

Hi,
I have a string:
mystring="1234,5678,985,21544,55524,11264, ... ,"

How can I divide this string into
1234
5678
985
....
11264
....

And then delete records corresponding to these separated strings?

delete from mytable where id = '1234'
....
delete from mytable where id = '11264'
....

Thanks for any help.

Atse

[dlbjr]

mystring = "1234,5678,985,21544,55524,11264, ... ,"
arrData = Split(mystring ,",")
For intCount = 0 To UBound(arrData )
Delete arrData (intCount )
Next

'This is not the most efficient way.
-dlbjr

Discerning resolutions for the alms

[atse]

Got it, thanks

"dlbjr" <do******@do.u> wrote in message
news:BO1jb.136$Qy4.11340@typhoon01...

mystring = "1234,5678,985,21544,55524,11264, ... ,"
arrData = Split(mystring ,",")
For intCount = 0 To UBound(arrData )
Delete arrData (intCount )
Next

'This is not the most efficient way.
-dlbjr

Discerning resolutions for the alms

[Dan Brussee]

On Wed, 15 Oct 2003 01:34:25 GMT, "atse" <du******@yahoo.com> wrote:

Hi,
I have a string:
mystring="1234,5678,985,21544,55524,11264, ... ,"

How can I divide this string into
1234
5678
985
...
11264
...

And then delete records corresponding to these separated strings?

delete from mytable where id = '1234'
...
delete from mytable where id = '11264'
...

Thanks for any help.

Atse

If the id is a string, you will need to build a string of comma
delimited single quoted values.

Once you get the string, use the Split command to get an array of
values.

A(0) will = "1234"
A(1) will = "5678"
etc.

From here, cycle through the array appending to a string
t = t & "'" & a(x) & &"',"

Now use an SQL state ment like
"delete from mytable where id in (" & t & ")"

However, if your id values are numeric, you are basically there. Use
the same method generate the sql statement, substituting the original
string for t.

[Manohar Kamath [MVP]]

How about using the string in the SQL statement

DELETE FROM myTable WHERE ID IN(12,23,34,45)

Simpler than deleting one record at a time.

--
Manohar Kamath
Editor, .netBooks
www.dotnetbooks.com
"atse" <du******@yahoo.com> wrote in message
news:Bu*********************@news01.bloor.is.net.c able.rogers.com...

Hi,
I have a string:
mystring="1234,5678,985,21544,55524,11264, ... ,"

How can I divide this string into
1234
5678
985
...
11264
...

And then delete records corresponding to these separated strings?

delete from mytable where id = '1234'
...
delete from mytable where id = '11264'
...

Thanks for any help.

Atse