select invoice_batch_no, substr(invoice_batch_no,instr(invoice_batch_no,'-')) from inv_invoice
--读取-分隔符,前面的字符,123-ABC 返回123
select invoice_batch_no, substr(invoice_batch_no,1,instr(invoice_batch_no,'-')-1) ||'-' from inv_invoice
select invoice_batch_no, substr(invoice_batch_no,instr(invoice_batch_no,'-')) from inv_invoice
--读取-分隔符,前面的字符,123-ABC 返回123
select invoice_batch_no, substr(invoice_batch_no,1,instr(invoice_batch_no,'-')-1) ||'-' from inv_invoice