Run Sql Action, how to get a value from SQL?

[maorlast2]

I am using Visual Build 7.7

I am trying to get a specific value from the database table
I am using “Run Sql” Action and using SELECT query

how can i set the value that i got from the db into a temp marco?
I also tried to take it from LASTSTEP_OUTPUT but i see this result:

“MyValue

(1 row affected)”

I would like to remove the “(1 row affected)” and get the exact value "MyValue"

How can I do that?