Query to remove pipe

Database
Enthusiast

Query to remove pipe

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

rgards,
New bie for teradata
2 REPLIES
Enthusiast

Re: Query to remove pipe

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:-)
Enthusiast

Re: Query to remove pipe

Great friend.that works..thnx