HOW TO USE STR VARIABLES IN SQL WHERE EXPRESSION, DAX 2009

I think most of us faced this issue , when we try to use str variable in X++ SQL statement like below

"Error: Container and unbounded string (text) fields are not allowed in a WHERE expression."

 

Because when trying to use unbounded string variable within a select / where expression , it is expecting a limited sized string , so the solution is to limit the size of variable as below

 

Eventhough we are using string EDT's we won't get this error , because each string EDT will have its size.