Variable in Where Clause in Axapta
<p>I have an update statement in a Job in axapta and I want to use a variable inside of the updates where clause</p>

<pre><code>static void UpdateSomeValues(Args _args)
{
    Table myTable;
    str likeThis;
    ;

    likeThis = 'W200';

    ttsBegin;
    select forUpdate myTable
    where myTable.start == 'W100'
    &amp;&amp; myTable.destination like likeThis;

    myTable.AlloweMove = NoYes::Yes;
    myTable.AllowStop = NoYes::Yes;

    ttsCommit;
}
</code></pre>

<p>The error I get is translated something like this:</p>

<p><em>unbound Strings are not allowed in the where clause</em></p>

<p>Is there a workaround to use Strings in the where clause in x++ ?</p>