Hi All,
I am trying to create output that contains a dimension and the user would like
to see single quote for feet and double quote for inches. I have not as yet
stumbled on the solution.
SELECT length_ft::text || \' ||
length_in::text || \" AS length_dim,
width_ft::text || \' ||
width_in::text || \" AS width_dim
FROM sales_order.tbl_net_production;
Kind Regards,
Keith