OK we what i am attempting to so is update part of a record in our database. In our call center people do not use the same abbreviation for street, avenue, and the like. So we want to run a SQL query to just search and replace data in those records.
Here is what we have come up with however it does not work correctly
update OECSSL set DNL1TX = 'ST' where DNCOMP = 10 and DNL1TX =
'STREET'
OECSSL = the Database
DNL1TX equals the address column
ST is what we would search for as the incorrect item that we want to replace with Street.
and we want to update records that have a DNCOMP that = 10 (DNCOMP is a column)
Currently with how this works, if the entire field = ST it will fix it, however if there is other data such as the whole address it will ignore it.
Question
Geoffrey B. Veteran
OK we what i am attempting to so is update part of a record in our database. In our call center people do not use the same abbreviation for street, avenue, and the like. So we want to run a SQL query to just search and replace data in those records.
Here is what we have come up with however it does not work correctly
OECSSL = the Database
DNL1TX equals the address column
ST is what we would search for as the incorrect item that we want to replace with Street.
and we want to update records that have a DNCOMP that = 10 (DNCOMP is a column)
Currently with how this works, if the entire field = ST it will fix it, however if there is other data such as the whole address it will ignore it.
Any help would be much appreciated Thank you.
Link to comment
Share on other sites
9 answers to this question
Recommended Posts