Retrieving 2 or more values from a DB query

[egun]

I have stored the results of a DB query in a variable, here's my code:

Code:

Set adIDs = db.execute(AdIDsSql)
val2 = adIDs.GetString
msgbox val2

The message box then displays the following (on separate lines):
TRAIN1
TRAIN2

How can I now store each in it's own varible? What method would take into account a line return? Tried the following but it doesn't work:

adj1 = LTrim(val2)
adj2 = RTrim(val2)