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.