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
*

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.

相关帖文	回复	查看
problem after updating UoM of a product database sql openerp7	2 6月 18	5900
How to block duplicating RECORDS (with the same employee_id)? constraint sql openerp7	0 12月 15	3484
Usage Of SQl Queries In odoo sql	1 11月 22	5563
Error: NameError: name 'field' is not defined openerp7	2 5月 22	33736
sql constraints aren't being detected in my model sql	1 10月 21	3240

此问题已终结

喜欢讨论吗？不要只阅读，加入进来！