For strings, the only way I know is through a cursor or temp table. Here's the cursor version

DECLARE @rowStr varchar(20),

    @totalStr varchar(2000)

DECLARE mytable_curs CURSOR FOR

SELECT tk_number from mytable

where tk_Battery = 6500

OPEN mytable_curs

fetch...