postgresl: order by first letter ascending

 

 

 

select
c_bpartner_id,
“name”,
em_mg_crm_account_id,
em_mg_sync_to_msupply
from
adempiere.c_bpartner
where
c_bp_group_id = ‘1000003’
— and em_mg_msupply_manufacturer_id is not null
and lower(c_bpartner.name) similar TO ‘[g-z]%’
order by
name asc;

Leave a Reply

Your email address will not be published.