How to split a character field value in sql query?

Question

Hi Friends,
How to split a character which is separated by (:) operator like OUT/1234: SO/14-15/345.I need output as SO/14-15/345 by only using sql query.Please help me in this situation.Thanks in advance.

Prakash · Accepted Answer

*select substring(column_name, position(':' in column_name)+1, length(column_name)) from table_name
*

https://mk-digital.in/, Mohit Kotak (MK) · Answer

Hello vadivel,
Try this query.

select *,
substring(dat,1,charindex('-',dat)-1) as Section,
substring(dat,charindex('-',dat)+1,charindex('-',dat)-1) as TownShip,
reverse(substring(reverse(dat),0,charindex('-',reverse(dat)))) as myRange
from myTable;

I hope it's work.
Thank you.

Relaterade inlägg	Svar	Vyer
problem after updating UoM of a product database sql openerp7	2 juni 18	7635
How to block duplicating RECORDS (with the same employee_id)? constraint sql openerp7	0 dec. 15	5071
Usage Of SQl Queries In odoo sql	1 nov. 22	10097
Error: NameError: name 'field' is not defined openerp7	2 maj 22	37405
sql constraints aren't being detected in my model sql	1 okt. 21	5743

Denna fråga har flaggats

Njuter du av diskussionen? Läs inte bara, delta också!