I have defined Custom Field 1 to hold the URL for an external database record. The database is powered by ColdFusion and we're changing the server it is hosted on. The data stored in USER_EXTRA_FIELD_1 is either blank or has a fully qualified URL in the format of http://domain_name.org/updtform1.cfm?id=375

The number at the end of the URL is a unique record pointer and can be anything from 1 to 999.

What I would like to do is run a SQL script that will allow me to strip out everything but the number at the end of the URL and save it back to USER_EXTRA_FIELD_1 as just the number in text form. If USER_EXTRA_FIELD_1 was blank, it just ignores the record. That way I can concatenate the new URL and the stored number without having to store the entire new URL.

Can anyone help me with the SQL script?