Hi, I'm using ASP with MS SQL 2000.
I have a recordset that looks something like this. It has only one column, called Identity_Name:
For comparison purposes, I need to alter this recordset so that all the occurances of "XXXX" are replaced with another 4 character string. Then, the recordset needs to be re-sorted. Let's say that we change "XXXX" to "ABCD." The resulting recordset should look like this:
Does anyone know of a clever way to do this using SQL only? I'd rather not dump the recordset into an ASP array and then sort it.