Another Database Question

I have the following code.

dim rs as recordset = karter.SQLSelect("select * from mytracks where PK = "+ str(mytrackspk)) txtspacers1.text = DefineEncoding(rs.Field("spacers").stringvalue, encodings.UTF8

This code works fine when pulled from the database, spacers is a size ie 12, how do I append another value to the spacers value, pulled from another record set as follows.

dim rs2 as recordset = karter.SQLSelect ("select  currency, measurement, temperature from preferences")

I wish to append the measurement value from the database, which in this case in “mm”

Thanks.

dim rs as recordset = karter.SQLSelect("select * from mytracks where PK = "+ str(mytrackspk)) dim rs2 as recordset = karter.SQLSelect ("select currency, measurement, temperature from preferences") txtspacers1.text = DefineEncoding(rs.Field("spacers").stringvalue + rs2.Field("measurement").StringValue, encodings.UTF8)

Thanks Wayne.