Vista - VB script - for accessing a array returned from stored procedure

In my Vb script i need to call a stored procedure by passing some
input parameters which returns an array. i'm able to handle when the
stored procedure returns number or char. i need help on how to handle
when the stored procedure returns an array.

thnx in advance

"Anand" <anandhanr@xxxxxx> wrote in message
news:77931fe8-6984-467e-9b35-4235f411f1ec@xxxxxxYou can test your variable with VarType and parse accordinly.

Select Case VarType(ReturnVar) > 8192
Case True
MsgBox "True", , VarType(ReturnVar)
'Code to handle or join array
Case False
MsgBox "False", , VarType(ReturnVar)
'Code to handle empty, null, number, character, etc
End Select

Question is, do you want the first or another specific element in the
array or do you want to join it together into a single string?