RE: Sqlplus Masking

To: pkane_at_diablo.cisco.com (Peter Kane) Subject: Re: Sqlplus Masking?

Try rtrim(char,[set])
page 4-17 in sql language reference Manual example from book
select rtrim('turner xxXxx','x') example from dual;
example

In article <1qmitlINNj88_at_cronkite.cisco.com>, you write:
|> I need to create a view that masks a '=' off the end of a character
|> string, but not all of the strings have the '='.
|>
|> For example, if I had:
|>
|> order_num part_num
|> --------- --------
|> S12345 ABC
|> S87654 ABC=
|>
|>
|> I need to mask off the '=' in the second record's part_num so I can
|> get a sum for 'ABC' that would include the 'ABC=' part.
|>
|> Any ideas?
|>
|> Thanks,
|>
|> Peter Kane
|> pkane_at_cisco.com

-- 
John Hawkins       || #define disclaimer(X) fprintf(stderr," X\n");
Northern Telecom   || Voice: 615-734-4468                 /* Able was I, ere */
200 Athens Way     || Fax:   615-734-4771                 /* I saw Elba      */
Nashville TN 37728 || Internet:  nvjhh01_at_NT.COM           /* Who?            */