Skip to Content
Former Member
Aug 01, 2008 at 03:58 PM

SQL Query with a variable?


In Inventory > Item Master Data > Properties

There are 'Property Name' and a column of checkboxes..

How can I write a query to select the Property Names when the checkboxes are checked?

My problem is the column of checkboxes does not show a table or column where its located, it only shows a variable..

Is there away I can use variables in my SQL query?

Any help is appreciated, thank you.