am 09.02.2006, um 11:54:43 +0530 mailte surabhi.ahuja folgendes: > Hi > hi i have varchar type fiels in a table. > > i want to make the following check, > > if it is having carets in the end, then those carets be removed. > > so if i get a string like abc def^^^^ > > i should be able to get abc def
Which version? I have 8.1 and can use regexp_replace for this: test=# select 'abc def^^^^'; ?column? ------------- abc def^^^^ (1 row) test=# select regexp_replace('abc def^^^^','[\\^]*$',''); regexp_replace ---------------- abc def (1 row) HTH, Andreas -- Andreas Kretschmer (Kontakt: siehe Header) Heynitz: 035242/47215, D1: 0160/7141639 GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net === Schollglas Unternehmensgruppe === ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings