Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
goodman2253
Yak Posting Veteran
88 Posts |
Posted - 2013-09-08 : 01:29:59
|
Hello All,I am using the select query as belowSelect country from table1 which give the output asCOUNTRYUSUSAUKMalaysiaFranceEuropeUSUSAI want to change whenever US comes it change to USA. So the output should be as below-:COUNTRYUSAUSAUKMalaysiaFranceEuropeUSAUSA |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
goodman2253
Yak Posting Veteran
88 Posts |
Posted - 2013-09-08 : 02:45:08
|
any function like regexp_replace. Because using case make the sql query execute very slow. For one case its fine, but If I have to use multiple then. I hope you understand my point |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|