Re: Sqlplus Masking?

pkane_at_diablo.cisco.com (Peter Kane) writes:
|> 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?

rtrim(part_num,'=') should be enough unless your string contains more than one trailing '='.

Roderick Manalac
Worldwide Support Received on Fri Apr 23 1993 - 09:12:20 CEST