-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
> I have a table with column filepath with contents that look like the > following: .. > Is there anyway to retrieve the directory information only regarding those > filepaths? SELECT rtrim(substring(filepath from '.+/'),'/') FROM mytable; - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200503232033 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iD8DBQFCQhkMvJuQZxSWSsgRAjTaAJ9zmgSOBH/Nre/XMw+JajBni8YyDwCg1DyV Cd5rIhi026KFoFZEFjMOYvI= =V9ov -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
