Are the values delimitered? If they are, place them in to a text variable and extract the first characters before the delimiter.
For example, if the string returned is "123456;4455;9999" then
Var = Left(Return_Var, Instr(Return_Var,";")-1)
The Instr function will find the first semi-colon and return its position - which is 7. The -1 deducts 1 making the value 6.
The Left function then returns the left most 6 characters - 123456
Senior Director Support Americas