Query to remove pipe

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

Query to remove pipe

Rate Topic

Display Mode

Topic Options

Author

Message

young chap

Posted 8/26/2008 10:29:16 AM

Junior Member

Group: Forum Members
Last Login: 2 days ago @ 1:12:26 AM
Posts: 15, Visits: 81

Hi
Can anybody provide me the query to remove pipe symbol from the string?

rgards,
New bie for teradata

young chap

Post #12735

smilever

Posted 8/27/2008 3:29:03 AM

Forum Member

Group: Forum Members
Last Login: 10/15/2008 9:11:28 AM
Posts: 27, Visits: 77

hi friend!

hope this query is helpful

sel substr(string,1,position ('|' in string)-1)||substr(string,position('|' in string)+1).

in place of string you can mention the string column and chek it

Cheers:-)

smilever

Post #12744

young chap

Posted 8/27/2008 7:04:57 AM

Junior Member

Group: Forum Members
Last Login: 2 days ago @ 1:12:26 AM
Posts: 15, Visits: 81

Great friend.that works..thnx

young chap

Post #12747

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 3:20pm