Problem with Strings

[thomasa]

Hi,

i have just a little problem by converting strings like this:

'2600;2605-2610;2620;2621'

this should be inserted into a sql statement...

'and firstvdn IN XXXXX and'

xxxxx should be the formated string...

later, the string should look like this:

and firstvdn between 2605 and 2610 or firstvdn = 2600 or firstvdn = 2620 or firstvdn = 2621

is this possible?

thx

[mithril]

$vnd1 = explode(";",$str);
$vnd2 = explode("-",$vnd1[1]);

$newStr = "and firstvdn between $vnd2[0] and $vnd2[1]";
while (list($key,$var) = each($vnd1))
 &bnsp$newStr .= " or $var";

-geoff