REPLACE behavior

Question

REPLACE behavior

auke.teeninga

SSC Journeyman

Points: 76
More actions
March 5, 2014 at 8:52 pm

#283066

Comments posted to this topic are about the item REPLACE behavior
March 6, 2014 at 1:32 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 25 total)

You must be logged in to reply to this topic. Login to reply

free_mascot One Orange Chip Points: 27169 More actions · Answer 1

Easy one, thanks.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

Hany Helmy SSChampion Points: 13921 More actions · Answer 2

Too easy, no need even to run the code this time 🙂

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Umer Akram SSC-Insane Points: 22209 More actions · Answer 3

Umer Akram

SSC-Insane

Points: 22209

March 5, 2014 at 11:50 pm

#1694547

nice question .. thanks for sharing

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 4

Interesting caveat, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Ford Fairlane SSCertifiable Points: 7664 More actions · Answer 5

Nice one thanks.

Hope this helps...

Ford Fairlane
Rock and Roll Detective

r.armstrong-finnerty SSC Enthusiast Points: 107 More actions · Answer 6

Good question!

In Oracle, the answer is 'ABC'.

Just shows that when you think you know something... sometimes you don't!

paul s-306273 SSChampion Points: 10730 More actions · Answer 7

paul s-306273

SSChampion

Points: 10730

March 6, 2014 at 2:04 am

#1694568

Easy - so why only 68% with correct answers?

auke.teeninga SSC Journeyman Points: 76 More actions · Answer 8

In many programming languages the third argument wouldn't even be evalutated if the second argument didn't appear in the first argument.

All these will just return 'ABC':

SELECT REPLACE('ABC', 'Z', 1)

SELECT REPLACE('ABC', 'Z', CURRENT_TIMESTAMP)

SELECT REPLACE('ABC', 'Z', '#$@%')

This one will return 'ABC' half of the time and NULL the other half.

SELECT REPLACE('ABC', 'Z', CASE WHEN RAND() < 0.5 THEN 'A' END)

I thought of making the problem more complex, but I figured that would result in more people just running the query instead of answering first! 😉

Richard Warr SSCertifiable Points: 6967 More actions · Answer 9

paul s-306273 (3/6/2014)
Easy - so why only 68% with correct answers?

Perhaps it wasn't as easy as some of the resident "experts" claim. It's anything but logical behaviour and you can only get the question correct if you know that caveat on the REPLACE function (or if you just run the code).

SQLWinther SSCertifiable Points: 6294 More actions · Answer 10

Thanks, easy one, it's even documented in BOL. 🙂

/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform

Ed Wagner SSC Guru Points: 287026 More actions · Answer 11

A simple one and we're at 65% correct.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

RLilj33 SSCrazy Points: 2153 More actions · Answer 12

Koen Verbeeck (3/6/2014)
Interesting caveat, thanks.

+1

ronmoses@gmail.com SSCarpal Tunnel Points: 4480 More actions · Answer 13

Richard Warr (3/6/2014)
It's anything but logical behaviour and you can only get the question correct if you know that caveat on the REPLACE function (or if you just run the code).

Developer A: "We have a bug in this function. Want me to fix it?"

Developer B: "Nah, just document it as normal behavior."

Developer A: "Done."

-----
a haiku...

NULL is not zero
NULL is not an empty string
NULL is the unknown