It doesn't seem to like replacing '-' along with anything else, as a workar= ound you could do this; GSDBP2> l 1 select regexp_replace(UPPER(regexp_replace('A-JBurk','[''''|"|;| |-|,|= .]')),'-') 2* from dual GSDBP2> / REGEXP ------ AJBURK Cheers, Ian This email is only intended for the person to whom it is addressed and may = contain confidential information. If you have received this email in error,= please notify the sender and delete this email which must not be copied, d= istributed or disclosed to any other person. Unless stated otherwise, the contents of this email are personal to the wri= ter and do not represent the official view of Ordnance Survey. Nor can any = contract be formed on Ordnance Survey's behalf via email. We reserve the ri= ght to monitor emails and attachments without prior notice. Thank you for your cooperation. Ordnance Survey Romsey Road Southampton SO16 4GU Tel: 023 8079 2000 http://www.ordnancesurvey.co.uk -- //www.freelists.org/webpage/oracle-l