Works. Thanks for the help. I will read the docs
Best
On 1/14/2021 4:37 PM, aNullValue (Drew Stemen) wrote:
At 2021-01-14T19:27:23-05:00, Bret Stern
sent:
query
select company_code, item_code, item_description, product_line,
udf_item_width, udf_item_length, sales_unit_measure, ''as mat_type
At 2021-01-14T19:27:23-05:00, Bret Stern
sent:
> query
>
> select company_code, item_code, item_description, product_line,
> udf_item_width, udf_item_length, sales_unit_measure, ''as mat_type from
> mas_combined_item_master where company_code='BUR' or company_code='SNJ'
> or company_code='EBC
query
select company_code, item_code, item_description, product_line,
udf_item_width, udf_item_length, sales_unit_measure, ''as mat_type from
mas_combined_item_master where company_code='BUR' or company_code='SNJ'
or company_code='EBC' and udf_edb_managed=''
and item_code LIKE 'S-%' order by