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	5906
How to block duplicating RECORDS (with the same employee_id)? constraint sql openerp7	0 12月 15	3487
Usage Of SQl Queries In odoo sql	1 11月 22	5574
Error: NameError: name 'field' is not defined openerp7	2 5月 22	33754
sql constraints aren't being detected in my model sql	1 10月 21	3251

此問題已被標幟

喜歡這則討論？不要只閱讀，加入發表意見吧！