Fashion

MSSQL : replace by NULL

By Theresa / December 13, 2021

Dears,

  SELECT replace('hello','e',NULL) -- returns NULL
  SELECT replace('hello','5',NULL) -- returns also NULL (Here I'd expect it does nothing ; since there is no '5' in 'hello')

The documentation clearly states:

Returns NULL if any one of the arguments is NULL.

So the behavior is explained.

Is there a workaround, meaning if a pattern is found in a string ; like ‘e’ in hello ; a NULL value is emitted?

Tags: , ,

You may also like

© 2025 Street Of Styles