call data from sql in processmaker

Question

i have a table in sql which is like this:

|  product code         |     weight|
| ----------------------|-----------|
|   1235896             |        0.5|
|    3256kms            |        1.5|
|   dk-kmsw             |         3 |

and the data type for [product code] is nvarchar now i want to call the weight by putting the product code in processmaker the code that i wrote is this:

select [weight] from table where [product code] = @#textVar047

and by this code i get nothing, i have changed the @# to @@, @= but it did not work.

how can i do this?

any comment is appreciated.

Answer 1

select CAST(weight AS nvarchar(max)) from table where [product code] = @@textVar047