SQL REPLACE()

Replace function, replaces a given set of characters in a string with another set of characters.


SYNTAX :
 REPLACE('STRING',character_1, character_2)

Table Name 'customers'

id

name

age

city

bill

1Tom34Paris5300
2Jhony51London 400
3Ram64Delhi20000.7
4Simon23Portland32.65



Online Execute/Compile

Quantitative Aptitude
Reasoning
Programming
Interview